[mysqli_query problems]

This finally worked:

<?php

for ($x = 0; $x < 131 ;$x++)
{
$ZZ = $_POST["z".$x];
if ($ZZ != '')
{echo $x.' = '.$ZZ.'<br>';

$sql='UPDATE photo01 SET PhotoText = ? WHERE id = ?';
$PhotoText = $ZZ;
$id_equal_to = $x;
 
/* Prepare statement */
$stmt = $conn->prepare($sql);
if($stmt === false) {
  trigger_error('Wrong SQL: ' . $sql . ' Error: ' . $conn->error, E_USER_ERROR);
}
 
/* Bind parameters. TYpes: s = string, i = integer, d = double,  b = blob */
$stmt->bind_param('si',$PhotoText,$id_equal_to);
 
/* Execute statement */
$stmt->execute();
 
$stmt->close();
}
}
?>

[mysqli_query problems]

I wrote a simple mysql record update.

mysqli_query($link, "UPDATE photo01 SET PhotoText='abcd' WHERE id= '1' ");

Work fine until I use a variable:

mysqli_query($link, "UPDATE photo01 SET PhotoText= $ZZ  WHERE id= $x ");

If $ZZ contains only number it updated the cell.

ANY letters does not.

The cell is text and standard US ASCII

I tried:

mysqli_query($link, "UPDATE photo01 SET PhotoText={$ZZ} WHERE id={$x}");

same problem

 

Here is my loop:

<?php
for ($x = 0; $x < 131 ;$x++) {
$ZZ = $_POST["z".$x];
if ($ZZ != '') {

mysqli_query($link, "UPDATE photo01 SET PhotoText={$ZZ} WHERE id={$x}");
}
}

?>