Posted by Norman Peelman on 07/08/06 00:40

"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
--
FREE Avatar hosting at www.easyavatar.com

[Back to original message]