websteve Posted September 11, 2010 Share Posted September 11, 2010 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()); } Link to comment https://forums.phpfreaks.com/topic/213175-trying-to-concatenate-variables-using-update/ Share on other sites More sharing options...
Pikachu2000 Posted September 11, 2010 Share Posted September 11, 2010 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()); } Link to comment https://forums.phpfreaks.com/topic/213175-trying-to-concatenate-variables-using-update/#findComment-1110035 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.