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 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 not checking error returns f

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_cnt"; } else { echo "Ouc

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