array posting

[searls03]

can anyone help me as to whay I get this error: Problem with the query: INSERT INTO options (item_id, option ) VALUES('1', 'hi' )

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 'option ) VALUES('1', 'hi' )' at line 1

 

with this code:

foreach($_POST["user"] AS $key => $val) {
$user = $val;
$id1 = $_POST['id1'][$key];


$sql = "INSERT INTO options (item_id, option ) 





VALUES('$id1', '$user' )";
$rs = mysql_query($sql) or die ("Problem with the query: $sql <br />" . mysql_error());


}

<input type="checkbox" name="yes" id="checkme" /><div id = "extra"> <div id="user"> Enter User Names:<br> <input type="text" name="user[]"/><br></div>
<div id="add_user" style="display: none;"><input type="text" name="user[]"/>

[chriscloyd]

 

<?php

$users = $_POST['user'];

foreach ($users as $key => $val) {

	$sql = "INSERT INTO options (`item_id`, `option`) VALUES ('{$key}', '{$val}' )";

	$rs = mysql_query($sql) or die ("Problem with the query: {$sql} <br />" . mysql_error());

}

?>

[/Code]

 

[Psycho]

And to find out why your query was failing and the one chriscloyd posted will work, you should look here:

 

http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html