nummber of database entrys..

[Anon]

I run a mysql database and want to create a query that counts all new database entryes that have bin done afther a surten date..

anyone know how the mysql query would look?

thanks a bunch 🙂

[Anon]

Well, obviously you have to have some column in the table where you have recorded a timestamp.

SELECT COUNT(*) as count from sometable where somecolumn > $somedate

[Anon]

thanks a bunch it worked great 🙂