[PHP-DB] RE: [PHP] date problem

2002-06-06 Thread Dan Hardiker
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

[PHP-DB] Re: [PHP] date problem

2002-06-05 Thread Miguel Cruz
On Thu, 6 Jun 2002, andy wrote: I would like to count the users out of a mysql db who registered after a certain date. The column I have in the db is a char and I do not want to change this anymore. This is how a typical entry looks like: May 29, 2002 This is how I tryed it: // while