Ok I made the changes and now I am getting these 2 errors... Warning: 0 is not a MySQL result index in search01.php on line 141 and this one... Warning: 0 is not a MySQL result index in search01.php on line 143 No rows found On line 141 - $count = mysql_num_rows($results); On line 143 - if (mysql_num_rows($results) ) I am not sure what this error message means, does that mean that there were no results to display? Oh by the way I sincerely want to thank you for helping me out with this, I have been working on it for a few days and just today decided I should get help with it. Thanks again. Jason
"Rick Emery" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > OK. Ya followed me just a little too literally. We needed you to > restructure. So you're part way there. > i've made some changes below. > > I don't have access to PHP here at work, otherwise I'd test the changes I > made below. So you'll have to test them. > > You'll note that I placed the while(){} loop where it should be. > I also split the Name line into two different array elements. The array > 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: 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,state,zip,phonea,phone,email,crty,crnum,crmo,cryr,w > eeks,ogden,rock,logan,ipaddress,ad,total,num,date,time > FROM ads WHERE date LIKE > '%$date%' LIMIT 0, 30 "); > $count = mysql_num_rows($results); > > if (mysql_num_rows($results) ) > { > while( $row = mysql_fetch_array($result) ) > { > > print "<B>Name: </B>".$row['fname'].", ".$row[' lname']."<BR>\n"; > print "<B>Address: </B>".$row['address']."<BR>\n"; > print "<B>City: </B>".$row['city']."<BR>\n"; > print "<B>State: </B>".$row['state']."<BR>\n"; > print "<B>Zip: </B>".$row['zip']."<BR>\n"; > print "<B>Phone: </B>".$row['phonea'].", ".$row[' phone']."<BR>\n"; > print "<B>Email: </B>".$row['email']."<BR>\n"; > print "<B>Credit Type: </B>".$row['crty']."<BR>\n"; > print "<B>Credit Number: </B>".$row['crnum']."<BR>\n"; > print "<B>Credit Date: </B>".$row['crmo']."<BR>\n"; > print "<B>Weeks: </B>".$row['weeks']."<BR>\n"; > print "<B>Ogden: </B>".$row['ogden']."<BR>\n"; > print "<B>Logan: </B>".$row['logan']."<BR>\n"; > print "<B>IP Address: </B>".$row['ipaddress']."<BR>\n"; > print "<B>Ad: </B>".$row['ad']."<BR>\n"; > print "<B>Total: </B>".$row['total']."<BR>\n"; > print "<B>Ad Number: </B>".$row['num']."<BR>\n"; > print "<B>Date: </B>".$row['date']."<BR>\n"; > print "<B>Time: </B>".$row['time']."<BR>\n"; > } > } > else { > print "No rows found"; > } > ?> > After I have uploaded it to the webserver I now get a parse error on line > 201 and that is the end of the php file, so there isn't anything to change. > > I am still fairly new to this so any help you can provide would be great. > Thanks again. > Jason > > > >From: Rick Emery <[EMAIL PROTECTED]> > >To: 'Jason' <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > >Subject: RE: [PHP-DB] Re: PHP and MySQL queries... > >Date: Tue, 23 Oct 2001 13:13:21 -0500 > > > >First o all, GET RID of the 19 constructs using mysql_result(). You've > >already captured the row with the $row=mysql_fetch_array(). > >mysql_result() cannot be mixed with mysql_fetch_arry(). > > > >So instead of: > >echo "<B>Address: </B>"; > >printf(mysql_result($result,$count,"address")); > >echo "<BR>\n"; > > > >use: > >print "<B>Address: </B>".$row['address']."<BR>\n"; > > > >Next, dates are stored in MySQL as YYYY-MM-DD. Use that format in your > >input. > > > >Next, don't combine that "if(mysql_fetch_array())" with the "do while()" > >Instead, 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: Tuesday, October 23, 2001 12:37 PM > >To: [EMAIL PROTECTED] > >Subject: [PHP-DB] Re: PHP and MySQL queries... > > > > > >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 > >almost certain that as the user clicks the submit button the php script is > >parsing the search string (i.e. 10/23/2001) incorrectly. I believe it is > >parsing the sting as 10&nsb;23&nsb;2001 or something to that effect. If > >anyone has some more information on this please let me know. I am pretty > >sure I have exhausted my resources. > > > >"Jason" <[EMAIL PROTECTED]> wrote in message > >[EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > I am having a hard time setting up a form for users to enter a date in > >the > > > format of 00/00/0000 (of course they would use an actual date). My form > >is > > > as follows... > > > <form name="auth" method="post" action="search.php"> > > > <p>*I.E. - Format is 04/01/2001*</p> > > > <p>Search for Ads by date: > > > <input type="text" name="date"> > > > </p> > > > <p> > > > <input type="submit" name="login" > > > value="Submit"> > > > <input type="reset" name="reset" > >value="Reset"> > > > </p> > > > </form> > > > ================================================ > > > On my search.php page I have the following MySQL connection and search > > > parameters... > > > <?php > > > > > > mysql_connect ("db_hostname", "db_username", "db_password"); > > > > > > mysql_select_db ("db_name"); > > > > > > if ($date == "") > > > {$date = '%';} > > > > > > $result = mysql_query ("SELECT > > > > >fname,lname,address,city,state,zip,phonea,phone,email,crty,crnum,crmo,cryr, > w > > > eeks,ogden,rock,logan,ipaddress,ad,total,num,date,time > > > FROM ads WHERE date LIKE '%$date%' LIMIT 0, 30 "); > > > $count = -1; > > > if ($row = mysql_fetch_array($result)) { > > > $count ++; > > > do { > > > echo "<B>Name: </B>"; > > > printf(mysql_result($result,$count,"fname")); > > > echo " "; > > > printf(mysql_result($result,$count,"lname")); > > > echo "<BR>\n"; > > > > > > echo "<B>Address: </B>"; > > > printf(mysql_result($result,$count,"address")); > > > echo "<BR>\n"; > > > > > > echo "<B>City: </B>"; > > > printf(mysql_result($result,$count,"city")); > > > echo "<BR>\n"; > > > > > > echo "<B>State: </B>"; > > > printf(mysql_result($result,$count,"state")); > > > echo "<BR>\n"; > > > > > > echo "<B>Zip: </B>"; > > > printf(mysql_result($result,$count,"zip")); > > > echo "<BR>\n"; > > > > > > echo "<B>Phone: </B>("; > > > printf(mysql_result($result,$count,"phonea")); > > > echo ") "; > > > printf(mysql_result($result,$count,"phone")); > > > echo "<BR>\n"; > > > > > > echo "<B>Email: </B>"; > > > printf(mysql_result($result,$count,"email")); > > > echo "<BR>\n"; > > > > > > echo "<B>Credit Type: </B>"; > > > printf(mysql_result($result,$count,"crty")); > > > echo "<BR>\n"; > > > > > > echo "<B>Credit Number: </B>"; > > > printf(mysql_result($result,$count,"crnum")); > > > echo "<BR>\n"; > > > > > > echo "<B>Credit Card Date: </B>"; > > > printf(mysql_result($result,$count,"crmo")); > > > echo " "; > > > printf(mysql_result($result,$count,"cryr")); > > > echo "<BR>\n"; > > > > > > echo "<B>Weeks: </B>"; > > > printf(mysql_result($result,$count,"weeks")); > > > echo "<BR>\n"; > > > > > > echo "<B>town1: </B>"; > > > printf(mysql_result($result,$count,"town1")); > > > echo "<BR>\n"; > > > > > > echo "<B>town2: </B>"; > > > printf(mysql_result($result,$count,"town2")); > > > echo "<BR>\n"; > > > > > > echo "<B>town3: </B>"; > > > printf(mysql_result($result,$count,"town3")); > > > echo "<BR>\n"; > > > > > > echo "<B>IP Address: </B>"; > > > printf(mysql_result($result,$count,"ipaddress")); > > > echo "<BR>\n"; > > > > > > echo "<B>Ad: </B>"; > > > > > > $ad[$count] = (mysql_result($result,$count,"ad")); > > > > > > $ad[$count] = ereg_replace ("&a&", "'", $ad[$count]); > > > $ad[$count] = ereg_replace ("&q&", "\"", $ad[$count]); > > > $ad[$count] = ereg_replace ("&p&", "%", $ad[$count]); > > > $ad[$count] = ereg_replace ("&bs&", "\\", $ad[$count]); > > > > > > > > > echo $ad[$count]; > > > echo "<BR>\n"; > > > > > > echo "<B>Total: </B>"; > > > printf(mysql_result($result,$count,"total")); > > > echo "<BR>\n"; > > > > > > echo "<B>Ad Number: </B>"; > > > printf(mysql_result($result,$count,"num")); > > > echo "<BR>\n"; > > > > > > echo "<B>Date: </B>"; > > > printf(mysql_result($result,$count,"date")); > > > echo "<BR>\n"; > > > > > > echo "<B>Time: </B>"; > > > printf(mysql_result($result,$count,"time")); > > > echo "<BR>\n"; > > > > > > } while($row = mysql_fetch_array($result)); > > > > > > } else {print "Sorry, no records were found!";} > > > > > > ?> > > > So far I have come to the conclusion that the input from the user is > > > probably where my problem is because I am assuming it is taking the "/" > >in > > > the date they enter and doing something I don't want it to. In any > >event > >if > > > someone could give me a clue as to how to resolve this issue it would be > > > greatly appreciated. > > > > > > > > > > > > > >-- > >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] > > > > > > > _________________________________________________________________ > Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > > -- 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]
