tags:

views:

22

answers:

1

how can i get mysql data after a specific timestamp..........!! means what shoud be the query

mysql_query("SELECT * FROM table where thenameoftimestamprow > than the date");

+2  A: 
SELECT * FROM table WHERE thenameoftimestamprow > '2009-01-28 21:00:00'
SELECT * FROM table WHERE thenameoftimestamprow > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 DAY)

And yes you should work on your acceptance rate

Shahmir Javaid