Re: [PHP-DB] Remnant data from previous queries when using mysql_fetch_array...

2003-02-06 Thread Doug Thompson
On Thu, 06 Feb 2003 10:33:23 -0700, Doug Thompson wrote: >Try getting the results from the query like the following. -snip- With the correct syntax. 8-( Doh! > >// >$numrows = mysql_num_rows ($result); > ^ -- PHP Database Mailing List (http:

Re: [PHP-DB] Remnant data from previous queries when using mysql_fetch_array...

2003-02-06 Thread Doug Thompson
Try getting the results from the query like the following. Doug // generate and execute query $query = "select * from changelog where changedBy = '$changedBy' or vendorNumber = '$vendorNumber' or oldName like '$oldName' or newName like '$newName' or newVendorNumber = '$newVendorNumber'"; $result

Re: [PHP-DB] Remnant data from previous queries when using mysql_fetch_array...

2003-02-06 Thread Mike Hilty
Okay, I figured out that the issue is not due to the PHP code, but by the query I'm using against the MySQL DB... What I need to know is how to structure the code where the query is based off of fields filled in by the user. I would like to structure the query where if the user provides a value f

RE: [PHP-DB] Remnant data from previous queries when using mysql_fetch_array...

2003-02-05 Thread John W. Holmes
> I am a novice PHP dev having a strange issue with mysql_fetch_array. > For some reason, it is keeping data from previous queries in the array, > and > displaying it in the web page. > My development platform is Win2k SP2, Apache 1.3.23, PHP 4.3.0, > MySQL-MAX 3.23.47-nt. > Here is the