Hi,

I have this situation on my hands, I need to display only todays links from the db, but the db table shows a row called date_added and the date is specified as month day, year format: Ex: June 12, 2011. How can I output only the rows with 'todays' date? Meaning tomorrow will be June 13, 2011, so only those will be on the page etc..

Thank you
-Brian

Something like:

SELECT col from tbl where day(date_col) = day(now());

Originally Posted by NullPointer

Something like:

SELECT col from tbl where day(date_col) = day(now());

That didn't quite work Matt, I get 0 results for that query. No errors, just 0 results, and I am sure there's a link in the database with todays date.

Just to clarify, is the datatype for the date column either 'date' or 'timestamp'?

Originally Posted by NullPointer

Just to clarify, is the datatype for the date column either 'date' or 'timestamp'?

Nope, varchar is the datatype...I don't know if I should change the datatype either, could that corrupt the script, needing another re-install?

Try

select col from tbl where date(str_to_date(date_col, '%M %d, %Y')) = date(now());

Originally Posted by NullPointer

Try

select col from tbl where date(str_to_date(date_col, '%M %d, %Y')) = date(now());

Still 0, but still no errors. Wait! The date is shown like this: 12 June 2011 (my mistake on the original post -- No seperation in the date either other than spaces, exactly as I posted is how it is in the db: 12 June 2011) so maybe the %M %d, %Y is wrong?

Yes, just remove the comma and the format should be correct.

In the future, if you're storing dates in a database it is best to use either the date or timestamp format.

Originally Posted by NullPointer

Yes, just remove the comma and the format should be correct.

In the future, if you're storing dates in a database it is best to use either the date or timestamp format.

Thank you Matt! Works as expected. Btw, the script was from linkstation pro for reciprocals, I found it to be better to use a pre-made script than to figure out the scripting, I like to leave that up to the pros. I just pretend to be one sometimes.