Thanks alot... right now I cannot really work on it but I am going to setup
a test table to work with so I make sure I get the correct results on the
test before I impliment it on our main tables. Thanks again, all of you guys
on this newsgroup have been a great help to a newbie like myself. =)
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...
Jason
/* Form to supply
understand what I mean :-)
Bruno Gimenes Pereti.
- Original Message -
From: Jason [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 30, 2001 3:31 PM
Subject: [PHP-DB] PHP query on date field
Here is my problem once again... =P I am wondering if I should change the
date table
.
{Hope this helps} else {tell us}.
Bruno Gimenes Pereti.
- Original Message -
From: Big Nickel [EMAIL PROTECTED]
To: Bruno Gimenes Pereti [EMAIL PROTECTED]
Sent: Tuesday, October 30, 2001 4:02 PM
Subject: Re: [PHP-DB] PHP query on date field
I apologize... there really isn't any error
Message-
From: Bruno Gimenes Pereti [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 11:42 AM
To: PHP-DB
Subject: Re: [PHP-DB] PHP query on date field
Hi Jason,
What is the error message, in what line? I really can't find any error...
Just one standarlization point: why do you use
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
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
On Wednesday 31 October 2001 02:57 am, [EMAIL PROTECTED] wrote:
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.
Hi again Jason,
I think Jason Wong got the problem I missed, it's the date format. If you
tested like I sad in the last mail you already found it. When you query:
SELECT * FROM ads WHERE date = '%$date%';
you get an empty result.
So, that's the solution...
Bruno Gimenes Pereti.
What is the
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
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
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
ry
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 com
This is what I'm saying...
I encourage you to try it and experiment.
-Original Message-
From: Jason [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 2:51 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] PHP query on date field
Just to clear some things up... so instead
On Wednesday 31 October 2001 04:34 am, Jason wrote:
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
The date field is varchar. And I believe it is for daylight savings. I am
trying out a couple of things on a test date field so I will get back with
you guys after I try your suggestions. And by the way I sincerely appriciate
all the help you and Rick are giving me. Thanks again,
jason
Jason Wong
On Wednesday 31 October 2001 05:11 am, Jason wrote:
The date field is varchar. And I believe it is for daylight savings.
I am trying out a couple of things on a test date field so I will get
back with you guys after I try your suggestions. And by the way I
sincerely appriciate all the help
17 matches
Mail list logo