Page 1 of 1

table del stuff

Posted: Tue Dec 13, 2005 6:44 pm
by elecktricity
I have a code like this:

Code: Select all

<input type='checkbox' name='val[]' value='table1-number1'>
<input type='checkbox' name='val[]' value='table1-number2'>
<input type='checkbox' name='val[]' value='table2-number4'>
<input type='checkbox' name='val[]' value='table6-number9'>
and on the next page have a query that updates it like this or something, im thinking like exploding it or something:

Code: Select all

$array = explode($table, "-", $number);
$query = "UPDATE $table SET number= '2' WHERE id='$number'";
or something like this, could somebody help me out? I think you can see what im trying to do

Posted: Tue Dec 13, 2005 7:45 pm
by shiznatix
do a foreach or somtin

Code: Select all

foreach ($_POST['val'] as $value)
{
  $arr = explode('-', $value);
  //$arr[0] = table name and $arr[1] = number
  $sql = 'UPDATE '.$arr[0].' SET numer='2' WHERE id="'.$arr[1].'"';
  $query = mysql_query($sql) or die(mysql_error());
}