Query will not work - SOLVED

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


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 />";

echo "Ouch result13<br />";


$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 />";

echo "Ouch result1<br />";

Here are my results:

Ouch result13

Row count result1 is 45

What am I doing wrong??


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.


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

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux