mysql query based on todays date
Posted: Sun Sep 20, 2009 12:47 am
For some reason, this isn't working. Any thoughts?
Also, I swipe this off a forum, but is not accurate PST date:
It says september 20, sunday eventhough it is still technically saturday over here. Is there a way to set the time zone dynamically, so depending upon where a user is, they get the right date. Any thoughts?
Code: Select all
$dtfoodcntquery = "SELECT * FROM FoodLib WHERE creatdt = $date";
Code: Select all
<?php
$my_t=getdate(date("U"));
print("$my_t[weekday], $my_t[month] $my_t[mday], $my_t[year]");
?>