Remnant data from previous queries when using mysql_fetch_array...
| From: | Mike Hilty | Date: | Thu, 06 Feb 2003 00:03:54 +0000 |
| Subject: | Remnant data from previous queries when using mysql_fetch_array... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25476@lists.php.net to get a copy of this message | ||
Hello,
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 code that I am using:
<?php
// open database connection
$connection = mysql_connect(localhost, username, password) or die ("Unable
to
connect!");
// select database
mysql_select_db(vendorNameChange) or die ("Unable to select database!");
// 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 = mysql_query($query) or die ("Error in query: $query. " .
mysql_error());
if ($row = mysql_fetch_array($result)) {
do {
print "<b><u>Old vendor number</u>: </b>";
print $row["vendorNumber"];
print "<br>";
<snip>
</snip>
} while($row = mysql_fetch_array($result));
} else {print "Sorry, no records were found!";}
// close database connection
mysql_close($connection);
?>
I am looking for a way to initialize the array, and display only the
data returned from the current query on the page. Any help with this would
be greatly appreciated.
Thanks,
Mike Hilty