>> 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 General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
