>> SELECT COUNT(*) AS c
>> FROM users_table
>> WHERE UNIX_TIMESTAMP( user_regdate ) > '1022882400'
> The only way you can do it with a char column is to select the entire
> database, load it into a PHP array, using strtotime() to (hopefully)
> convert "May 29, 2002", etc, into a unix timestamp, and then sort by
> that timestamp.
Alternatively you could use the query you are now (if its returning the
correct subset of rows from the table). Replace COUNT(*) AS c with your
primary key field (eg: id), and then use mysql_count_row() [rtfm for more
details] rather than pulling the rows. From here it looks like your
fastest option, but your not providing enough information.
Dan Hardiker [[EMAIL PROTECTED]]
ADAM Software & Systems Engineer
First Creative Ltd
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php