RE: [PHP] date problem
| From: | Dan Hardiker | Date: | Thu, 06 Jun 2002 10:43:00 +0000 |
| Subject: | RE: [PHP] date problem | ||
| References: | 1 2 | Groups: | php.db php.general |
| Request: | Send a blank email to php-db+get-19640@lists.php.net to get a copy of this message | ||
>> 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 [dhardiker@staff.firstcreative.net]
ADAM Software & Systems Engineer
First Creative Ltd