UPDATE PHP, MySQL

webAmeteur

I am trying to update more than 1 row in a dable using the same update.

I have upto 10 hiddenFields, each with an 'INT' value in. Each value refers to a different row in a table called 'screens'

Here is the code:

if ((isset($POST["MM_update"])) && ($POST["MM_update"] == "form2")) {
$updateSQL = sprintf("UPDATE screens SET seat_status='BOOKED' WHERE seat_number=%s", GetSQLValueString($POST['hiddenField0'], "int"),
"AND seat_number=%s", GetSQLValueString($POST['hiddenField1'], "int"));

When executing this, it only updates the first ValueString(hiddenField0) and not the others, in this case hiddenFiled1.

Any ideas on how I can achieve this.

Regards

devinemke

code your form to return all of the hidden fields as an array...

<input type="hidden" name="seats[]" value="1">
<input type="hidden" name="seats[]" value="2">
<input type="hidden" name="seats[]" value="3">
etc...

...then do this on your form processor:

$sql = "UPDATE screens SET seat_status = 'BOOKED' WHERE seat_number IN(" . implode(',', $_POST['seats']) . ')';

webAmeteur

I tried that but the code return Query was Empty

I have changed the hiddenFields to textFields, and the values are definately going into the textboxes

Regards

devinemke

Originally posted by webAmeteur
I tried that but the code return Query was Empty

it's a UPDATE query so it's not going to return anything (other than a BOOLEAN value).

webAmeteur

Sorry, my mistake. I had an incorrect value.

Having changed that though the following happens

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ',,,)' at line 1

devinemke

here is simplified example:

<?php
if (!isset($_POST['submit']))
{
	echo '
	<form action="" method="POST">
	<input type="hidden" name="seats[]" value="1">
	<input type="hidden" name="seats[]" value="2">
	<input type="hidden" name="seats[]" value="3">
	<input type="hidden" name="seats[]" value="4">
	<input type="hidden" name="seats[]" value="5">
	<input type="submit" name="submit" value="submit">
	</form>
	';
}
else
{
	$sql = "UPDATE screens SET seat_status = 'BOOKED' WHERE seat_number IN(" . implode(',', $_POST['seats']) . ')';
	echo $sql; // just for testing
}
?>