t; element names refer directly to the variables after SELECT in your SELECT
> query.
> I did the same in the Phone line.
>
> -Original Message-
> From: Jason Gerfen [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 23, 2001 2:23 PM
> To: [EMAIL PROTECTED]
> Subject
uot;Address: ";
> > printf(mysql_result($result,$count,"address"));
> > echo "\n";
> >
> > use:
> > print "Address: ".$row['address']."\n";
> >
> > Next, dates are stored in MySQL as YYYY-MM-DD. Use that
MAIL PROTECTED]]
Sent: Tuesday, October 23, 2001 2:23 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Re: PHP and MySQL queries...
Ok here is what I have done after your suggestions...
if ($date == "")
{$date = '%';}
$result = mysql_query ("SELECT
fname,lname,address,city,s
> while( $row = mysql_fetch_array($result) )
> {
> }
> }
> else {
> print "No rows found";
> }
>
> Do the above. Re-submit. Tell me the results. W'ell go from there...
>
> rick
>
> -Original Message-
> From: Jason [mailto:[EMAIL
ad, use:
if (mysql_num_rows($results) )
{
while( $row = mysql_fetch_array($result) )
{
}
}
else {
print "No rows found";
}
Do the above. Re-submit. Tell me the results. W'ell go from there...
rick
-Original Message-
From: Jason [mailto:[EMAIL PROTECTED]]
Sent: Tuesda
As of yet I have tried all sorts for date formating for the search field to
work. I.E. 2001-10-23, 10/23/2001, 10/%/2001, 10%, %10%, etc. The date
field in the database is stored as 10/23/2001 and yet when a user enters the
date and clicks the search button it does not display the results. I am
I'm not positive, but try switching the day and month fields. ie:
28/04/1981 for April 28th, 1981 instead of 04/28/1981
Could work... I know alot of programs, etc, use this format, and I cant
remember offhand right now. Let me know if it works for you!!
--
Jason Wood
Chief Technology Office
