Listing members who joined in the past week?

[rawnet]

Hi Chen,

Thanks for such a quick response. I've tried that code - no records are being returned, so maybe I'm being a bit stupid? :

PHP Code:

$query="SELECT    user.userid, user.joindate, userfield.field11, userfield.field12, userfield.field14, userfield.field15, userfield.field24
                FROM user
                LEFT JOIN userfield USING (userid)
                WHERE user.joindate > NOW()-(60*60*24*7)
                ORDER BY user.joindate DESC"; 


Without the WHERE clause it returns members okay (I had a LIMIT 10 on previously)

Results can be seen at http://www.servicepals.com/latestmembers.php

Is there anything else I might be missing?

Thanks for your help,

Ross