[PHP-DB] Query will not work - SOLVED

2013-02-02 Thread Ethan Rosenberg, PhD
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

Re: [PHP-DB] Query will not work - SOLVED

2013-02-02 Thread Karl DeSaulniers
$sql13 = UPDATE `Customers` SET `Lname` = 'Barnet', `City` = 'Lakewood', `State` = 'NJ' WHERE `Cust_Num` = 1089; $result13 = mysqli_query($cxn, $sql13); if(mysqli_num_rows($result13) 0) { $row_cnt = mysqli_num_rows($result13); echo row count result13 is $row_cntbr /; } else { echo Ouch

Re: [PHP-DB] Query will not work - SOLVED

2013-02-02 Thread tamouse mailing lists
On Sat, Feb 2, 2013 at 8:08 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: I must be missing something fundamental!! Yes. I was using the worker@localhost, which did not have the Update privilege. Added the privilege that, and everything worked. Please explain why you are