Query will not work - SOLVED

["Ethan Rosenberg, PhD" <erosenberg@xxxxxxxxxxxxxxxxxxxx>]

I  must be missing something fundamental!!

Here is a code snippet:

$sql13 = " UPDATE Customers SET Lname = 'Barnet',  City = 'Lakewood',  
State = 'NJ' WHERE Cust_Num = 1089";

$result13 = mysqli_query($cxn, "UPDATE Customers SET Lname = 'Bleich',  
City = 'Lakewood',  State = 'NJ' WHERE Cust_Num = 1089");

if($row_cnt = mysqli_num_rows($result13)!= 0)
{
   $row_cnt = mysqli_num_rows($result13);
   echo "row count result13 is $row_cnt<br />";
}

else
{
echo "Ouch result13<br />";
}

mysqli_free_result($result13);

$sql1 = "select Cust_Num, Fname, Lname, Street, City, State, Zip, Phone, 
Notes from Customers order by Cust_Num";

$result1 = mysqli_query($cxn, $sql1);

if($row_cnt = mysqli_num_rows($result1)!= 0)
{
$row_cnt = mysqli_num_rows($result1);
echo "Row count result1 is $row_cnt<br />";
}

else
{
echo "Ouch result1<br />";
}

Here are my results:


Ouch result13

Row count result1 is 45

What am I doing wrong??

Ethan
=============


I was using the "worker@localhost", which did not have the Update 
privilege. Added the privilege that, and everything worked.

Sorry for bothering you with trivia.

Ethan



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php