Assuming you correct the hours calculation per my previous email, then: $format = ($Hou>12?) "PM" : "AM" ; $Hou -= ($Hou>12?) 12 : 0;
And you can do away with all the constructs. -----Original Message----- From: Rick Emery Sent: Tuesday, October 30, 2001 2:09 PM To: 'Jason'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] PHP query on "date" field Jason, date("H") converts to a 24-hour clock. That is, 00 is 12 mid-night, 01 is 1 AM, 13 is 1 PM, 14 is 2 PM, 23 is 11 PM, etc. I do not understand the reasons for your computation that, say 00, is 10 PM. -----Original Message----- From: Jason [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 2:20 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] PHP query on "date" field Ok well I have made the changes and tested it out but using the search string 10/15/2001 still provided no results... here is the script that parses the date for entry into the database... $date = (date("m/d/Y")) ; #this date is used in the online database $A = (date("A")); $Hou = (date("H")); if ($Hou == 00){ $Hou = "10"; $format = "PM"; } if ($Hou == 01){ $Hou = "11"; $format = "PM"; } if ($Hou == 02){ $Hou = "12"; $format = "AM"; } if ($Hou == 03){ $Hou = "01"; $format = "AM"; } if ($Hou == 04){ $Hou = "02"; $format = "AM"; } if ($Hou == 05){ $Hou = "03"; $format = "AM"; } if ($Hou == 06){ $Hou = "04"; $format = "AM"; } if ($Hou == 07){ $Hou = "05"; $format = "AM"; } if ($Hou == 08){ $Hou = "06"; $format = "AM"; } if ($Hou == 09){ $Hou = "07"; $format = "AM"; } if ($Hou == 10){ $Hou = "08"; $format = "AM"; } if ($Hou == 11){ $Hou = "09"; $format = "AM"; } if ($Hou == 12){ $Hou = "10"; $format = "AM"; } if ($Hou == 13){ $Hou = "11"; $format = "AM"; } if ($Hou == 14){ $Hou = "12"; $format = "PM"; } if ($Hou == 15){ $Hou = "01"; $format = "PM"; } if ($Hou == 16){ $Hou = "02"; $format = "PM"; } if ($Hou == 17){ $Hou = "03"; $format = "PM"; } if ($Hou == 18){ $Hou = "04"; $format = "PM"; } if ($Hou == 19){ $Hou = "05"; $format = "PM"; } if ($Hou == 20){ $Hou = "06"; $format = "PM"; } if ($Hou == 21){ $Hou = "07"; $format = "PM"; } if ($Hou == 22){ $Hou = "08"; $format = "PM"; } if ($Hou == 23){ $Hou = "09"; $format = "PM"; } I am wondering if I should let the date be put into the db as 2001-15-10... <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Isn't date a reserved word that should not be used as a field name? It > appeared that what was asked was if he should change the name of his field > from date to date_1. It should definitely be changed if it is now called > date. > > > Jason Wong <[EMAIL PROTECTED]> said: > > > On Wednesday 31 October 2001 01:31 am, Jason wrote: > > > > > Here is my problem once again... =P I am wondering if I should change > > > the date table to something other than date... maybe something like > > > date_1? Would doing that resolve my issue, because of the fact that > > > the date variable in php is function? Thanks in advance... > > > > What is the format of date as defined in your database? If date is of > > type DATE or DATETIME then > > > > > $result = mysql_query ("SELECT * FROM ads > > > WHERE fname LIKE '%$fname%' AND lname LIKE > > > '%$lname%' AND phonea LIKE '%$phonea%' AND phone LIKE '%$phone%' AND > > > date LIKE '%$date%'"); > > > > should be changed to: > > > > $result = mysql_query ("SELECT * FROM ads > > WHERE fname LIKE '%$fname%' > > AND lname LIKE '%$lname%' > > AND phonea LIKE '%$phonea%' > > AND phone LIKE '%$phone%' > > AND date = '$date'" > > ); > > hth > > -- > > Jason Wong > > Gremlins Associates > > www.gremlins.com.hk > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > > -- > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]