MySQL multiple row updates

[Anon]

Hi,

Bit new to this game, but essentially I'm a little unsure as to how to use a MySQL statement to update a bunch of rows in a calendar of events to indicate that tickets are selling quickly for that event. It's essential that the form allows the user to check a number of events in one go. My calendar while loop contains this:

<input type=\"checkbox\" name=\"going_fast[$cal_id]\" value=\"1\">

Which I'm guessing I must process with something along the lines of this:

$going_fast_sql = "UPDATE calendar SET LOOP ticket_status=\"$going_fast[]\" WHERE cal_id=\"$cal_id\" ";

I know this isn't right, and I've probably got to rethink the use of the arrays in here somewhere, but I'm not sure how to do that or make the SQL update several rows.

[jblallement]

Hi,

If you name your checkbox check[]( or whatever name you like ) you will get an array in the post/get vars.
Then implode the array with commas and build a query using a IN operator.

A little sample will be clearer than my speech.

----8<----8<----
<?php

if (isset($submit)) {
$in = implode($check,",");

    $sql = " UPDATE calendar SET ticket_status = 1 WHERE cal_id IN ( $in ) ";

    /*
    bla
    bla
    ...
    ...   Execute the statement here
    ...
    bla
    bla

    */

}

?>
<hr>
<form name=testform
method=GET
action=<? echo $PHP_SELF; ?>

<?php
for ( $i=0; $i< 10 ; $i++ ) {
/ Change the value of the checkbox from $i to cal_id[$i]
Where cal_id is an array of cal_ids
/
echo "<input type=checkbox name=\"check[]\" value=\"$i\">\n";

    }

?>
<input type=submit name=submit value=Submit>

</form>
----8<----8<----

Try this, understand this and ask questions if not clear.

Hope this helps