Rick,
This portion of the site was done by a previous employee and well you
know the expression.. "If its not broke don't fix it." Well now that I
cannot query the db by the date it is now broke and I am still figuring out
how MySQL is taking entries to the db so I figured this bit of information
would maybe sum up the problem in the date field. I have been reading up on
the date function in the MySQL book I have but somethings it just doesn't
cover. So please excuse my being vague. Thanks,
Jason
"Rick Emery" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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]
