Re: [PHP] php/mySQL time comparison

2003-03-14 Thread CPT John W. Holmes
> Try quoting your dates - you could also edit your code by using the > BETWEEN SQL keywors. Using the less than / greater than method is slightly faster and probably more portable. I don't know how many databases implement BETWEEN. ---John Holmes... -- PHP General Mailing List (http://www.php

Re: [PHP] php/mySQL time comparison

2003-03-14 Thread Brad Wright
acqua i bacilli -- In wine there is truth, in beer there is strength, in water there are bacteria > From: Brad Wright <[EMAIL PROTECTED]> > Date: Sat, 15 Mar 2003 00:33:15 +1000 > To: <[EMAIL PROTECTED]> > S

Re: [PHP] php/mySQL time comparison

2003-03-14 Thread php-editors.com
Try quoting your dates - you could also edit your code by using the BETWEEN SQL keywors. hope this helps |-| |- www.php-editors.com| |- php programming contests | |- php tool reviews | |- php everything else| |-|

Re: [PHP] php/mySQL time comparison

2003-03-14 Thread Jason Wong
On Friday 14 March 2003 22:33, Brad Wright wrote: > 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: 2

Re: [PHP] php/mySQL time comparison

2003-03-14 Thread CPT John W. Holmes
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

[PHP] php/mySQL time comparison

2003-03-14 Thread Brad Wright
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 'end