Hi there I have a table which holds news that users add as they wish, each news add is added along with the date using

$tm= date("Y-m-d H:i:s");

I want to display the news back. This i can do, however is there any way at all that I can make the select statement only select news from todays date only:

so

select * from news where date = "todays date";

obviously I dont think "todays date" would do it, I have put it there as an example.

Any help greatly appreciated thanks

date is a reserved word so should not be used as a column name.

... date = curdate();

As Chris said, but only if your "date" field is a date related datatype.
If you store the date in a varchar field, then you will need to convert it to datetime before.