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
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
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
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
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