$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
