Jump to content

Searching MYSQL using date not datetime


blmg2009

Recommended Posts

Hi there, 

 

I'm a bit of a newbie and I have done a search online, but i'm still confused. 

 

I need to search my MYSQL database in a filed named date_mod I need to search for todays date only $date=gmdate("Y-m-d");

 

But however the field is a datetime option so how can I search only todays date and not both date and time. 

 

Thank you for reading. 

Link to comment
https://forums.phpfreaks.com/topic/291153-searching-mysql-using-date-not-datetime/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.