Jump to content

Trying to Concatenate Variables using Update


websteve

Recommended Posts

I can't get this syntax right. Every way I do it, it ends up putting zeros in the database. Can someone help me with the right syntax for concatenating variables within an Update statement?  Here's the most recent code I've tried:

 

for ($n=0; $n<=num_rows; $n++)

  {

    $pur_update = "UPDATE Purchasing SET Item='$item.$n', Description='$description.$n', Quantity='$quantity.$n', Price='$price.$n', Status='$status.$n', Comments='$comments.$n' WHERE Status = 'Undelivered' AND ID = '" . mysql_real_escape_string($cust_id) . "'";

mysql_query($pur_update)or die('Could not update Purchasing table Or there is nothing to update: ' . mysql_error());

  }

Just drop the concatenation operators within the double-quoted string.

for ($n=0; $n<=num_rows; $n++)
  {
    $pur_update = "UPDATE Purchasing SET Item='$item$n', Description='$description$n', Quantity='$quantity$n', Price='$price$n', Status='$status$n', Comments='$comments$n' WHERE Status = 'Undelivered' AND ID = '" . mysql_real_escape_string($cust_id) . "'";
   mysql_query($pur_update)or die('Could not update Purchasing table Or there is nothing to update: ' . mysql_error());
  }

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.