mysql UPDATE with php column1 SET = array[0][0]?

Question

I'm having a problem with updating a value in a column in my database. I can get it to work if i use

$result1 = mysqli_query($con,"UPDATE Customers SET NextExpectedCut = 222 WHERE Name = 'ruth'");

But I entered all the databases information into an array ($rows).. so there for I tested already by doing:

echo $rows[0][0];

And i get the first customers name on the browser so why cant I get this to work? Am I formatting it wrong or is there a different way to do this?

if(isset($_GET['test']) && $_GET['test'] =="1")
{
   $result = mysqli_query($con,"SELECT * FROM Customers");

   while($row = mysqli_fetch_array($result))
   {
      $rows[]=$row;

   }

echo $rows[0][0] ." is finished";

$result1= mysqli_query($con,"UPDATE Customers SET NextExpectedCut = 222 WHERE Name = $rows[0][0]");

dethtron5000 · Accepted Answer · 2013-07-09 01:20:25Z

1

You will need to denote your array with brackets and quote your input:

$result1= mysqli_query($con,"UPDATE Customers SET NextExpectedCut = 222 WHERE Name = '{$rows[0][0]}'");

or concatenate your string

$result1= mysqli_query($con,"UPDATE Customers SET NextExpectedCut = 222 WHERE Name = '".$rows[0][0]."'");

You may wish to use a prepared statement instead of a generated query instead: http://php.net/manual/en/mysqli.prepare.php. Prepared statements are generally safer than generated queries.

answered Jul 9, 2013 at 1:20

dethtron5000

10.9k1 gold badge33 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mysql UPDATE with php column1 SET = array[0][0]?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related