Re: PHP query on "date" field

Just to clear some things up... so instead of the long winded bit of code that was previously setup to change the format of the date for the date field in the db, I should use the 2 lines of code? Definately skeptical on this one... but you know more about this than I. "Rick Emery" <remery@excel.com> wrote in message news:EAA093B474ABD311A71E00508B5FE08305C2CB74@adntex03.us.excel.com... > 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'; php-db@lists.php.net > 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:jlgerfen@hotmail.com] > Sent: Tuesday, October 30, 2001 2:20 PM > To: php-db@lists.php.net > 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... > > <biorn@ebmstpa.com> wrote in message > news:200110301857.LAA04270@ns.ebmstpa.com... > > 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 <phplist@gremlins.com.hk> 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: php-db-unsubscribe@lists.php.net > > > For additional commands, e-mail: php-db-help@lists.php.net > > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > > > > > > -- > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >