$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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
