[PHP-DB] date problem From: andy (news.letters <email protected>)
Date: 06/06/02

Hi there,

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 '10...' is unix timestamp june 1, 02
SELECT COUNT(*) AS c
FROM users_table
WHERE UNIX_TIMESTAMP( user_regdate ) > '1022882400'

Thanx for any help on that,

andy

query 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php