I have a field in my table called created_at that is a time stamp. I am trying to write a query where is will give me data where the date in time stamp is the current date.
$result = mysql_query("SELECT *FROM visitors WHERE DATE(FROM_UNIXTIME(created_at)) =
CURDATE()") or die(mysql_error());
I looked up how to get date from time stamp that is why I am using DATE(FROM_UNIXTIME(created_at)). My query is coming back with nothing found, but I do have created_at fields in my db that are todays date. What am I doing wrong?