Welcome to WebmasterWorld Guest from 22.214.171.124
Forum Moderators: open
I've learned about NOW(), but are there similar commands for looking up times in the past or future?
Right now I'm using the following structure:
$query=mysql_query("SELECT * FROM table WHERE created>='".date("Y-m-d H:i:s",time()-1800)."'");
Also, if I wanted to look up data that meets one requirement and one and/or the other of the a second requirement, can I use the following structure:
SELECT * FROM table WHERE x='$x' AND (y='$y' ¦¦ z='$z')
It seems to work for me, but I just wanted to make sure I'm not opening room for a bug or performance issues.
SELECT YEAR(thedate) as year
WHERE YEAR(thedate) < '2010' && YEAR(thedate) > '2000';