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
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