Posted by Harold on 07/08/06 02:02

Hello Norman,

> "Harold" <harhem@cogeco.ca> wrote in message
> news:c9b3d92972fa8c86ff75207bcde@news.cogeco.ca...
>> i still can not get the checkboxes to write to the database
>>
>> i have a table called skills with the following fields - skillid,
>>
> fl_user
>
>> This is how i have tyhe checkbox option written
>>
>> <td><input type="checkbox" name="skill[]" value="16"> Delphi</td>
>>
>> This code always comes up with the error message
>>
>> foreach ($_POST['skill'] as $skill) {
>> mysql_query("INSERT INTO skills (skillid ,fl_user) " .
>> "VALUES ($skill, userid)");
>> $result = mysql_query($query) or die('Could not execute INSERT
>> query');
>> }
>> What am i doing wrong??
>>
> foreach ($_POST['skill'] as $skill)
> {
> $query = "INSERT INTO skills (skillid ,fl_user) VALUES
> ($skill,
> userid)";
> $result = mysql_query($query); // or die('Could not execute
> INSERT
> query');
> if (!$result)
> {
> echo '<br>MySQL: '.mysql_errno().' -
> '.mysql_error().'<br>';
> echo "$query <br>";
> }
> }
> ----
>
> will help...
>
> Norm
>


Thanks Norm : however it still did not work for me..
note i did change the $result line to $result = mysql_query($query) or
die('Could not execute INSERT query');

[Back to original message]