Re: php/mySQL time comparison

$timeFrom and $timeTo need to be surrounded by quotes within your SQL query for the format you're using. $query = "select * from Job_TB where teamNo = $teamNo AND startTime >= '$timeFrom' AND endTime <= '$timeTo'"; ---John Holmes... ----- Original Message ----- From: "Brad Wright" <bradwright@optushome.com.au> To: <php-general@lists.php.net> Sent: Friday, March 14, 2003 9:33 AM Subject: [PHP] php/mySQL time comparison Hi all, I have been tearing my hair out for weeks with this problem, hope someone can help. I want to pull all data out of a mysql table that falls between two dates (a start-time and end-time). I use PHP to allow the user to specify the time interval, creating 2 variables 'startTime' and 'endTime'. These are formatted thus: 2002-02-25 00:00:00 (YYYY-MM-DD HH:mm:ss). I then use the syntax: $query = "select * from Job_TB where teamNo = $teamNo AND startTime >= $timeFrom AND endTime <= $timeTo"; $result = mysql_query($query,$db) or die ("somethings wrong"); to query the mysql DB. But it doesnt work. Is there a glaring error in my syntax? Can anyone help with this as its driving me nuts Hope someone can help, thanks in advance, brad Cheers, Brad Nel vino la verità, nella birra la forza, nell'acqua i bacilli -------------------------------------------------------------------------- In wine there is truth, in beer there is strength, in water there are bacteria -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php