Yeah, that does give me a

Dami — Fri, 10 Sep 2010 01:47:56 +0000

Yeah, that does give me a jumping off place. I was having a time figuring out how to insert the selected features into the association table. This is very helpful.

Thanks so very much!

You would loop through your

teammatt3 — Fri, 10 Sep 2010 00:27:40 +0000

You would loop through your features table, and generate all the checkboxes:

<input type="checkbox" name="features[1]" value="1" />4 wheel drive
<input type="checkbox" name="features[2]" value="1" />Power steering 
<input type="checkbox" name="features[3]" value="1" />ABS
...

Notice that the primary key of your features table is inside the brackets of the input name.

When that form is submitted, you'll get $_POST['features'] that is, itself, an array of all the form elements that were checked. So you would loop through them, and insert them into your Car-Features table:

<?php
$car_id = (int)$_POST['car_id'];
// delete all the old features
query("DELETE FROM CarFeatures WHERE car_id = $car_id");

// loop through all the new features, and insert
foreach($_POST['features'] as $feature_id => $v){
    $feature_id = (int)$feature_id;
   $sql = "INSERT INTO CarFeatures(car_id, feature_id) VALUES($car_id, $feature_id)";
   query($sql);
}
?>

Does that help?