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=http://www.phpbuilder.com/board/archive/index.php/\"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.
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=http://www.phpbuilder.com/board/archive/index.php/\"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.