Multiple Values Multiple Tables

programmer79

I have the following table setup (simplified)

(Vehicle )

vehicle_id
text1

(Vehicle_feature)

vehicle_id
feature_id

(Feature)

feature_id
text1

I insert a row into Vehicle. After this has been done, I want to insert multiple values into Vehicle_feature, which has the vehicle_id. I use LAST_INSERT_ID(), to get vehicle_id inserted into vehicle_feature. Where I run into the problem.. There are checkboxes on the form for up to 50 features. Either the feature is on the vehicle or not, so how do I check each feature and insert if it is checked. I'm sure some kind of loop and probably simple at that, but one of those I just can't seem to tackle.

Thanks in advance,

Tony

LordShryku

Well, you could name all the checkboxes something like options[] to create an array, and assign a value="something" for them. That way, if they are checked, they will be put in the array. then on the next page, a small loop can be done to insert them all for you.

$sql = "INSERT INTO Vehicle_feature VALUES ";
for($i=0;$i<$_POST['options'];$i++) {
    $sql .= "('".$_POST['vehicle_id']."', '".$_POST['options'][$i]."')";
}
mysql_query($sql);

Something like that. If you don't want to modify your current form, post some code so we can see what you're doing.

programmer79

LordShryku --
Exactly what I was looking for.

Thank you very much!

LordShryku

Small updates here. You'll want to put a comma after those except ofr the very last one. Then the query will run them all at once. Or you could run them seperatly...

// all at once
$sql = "INSERT INTO Vehicle_feature VALUES "; 
for($i=0;$i<count($_POST['options']);$i++) { 
    $sql .= "('".$_POST['vehicle_id']."', '".$_POST['options'][$i]."')";
    if($i != (count($_POST['options']) - 1) {
        $sql .= ", ";
    }
} 
mysql_query($sql);

// one at a time
for($i=0;$i<count($_POST['options']);$i++) { 
    $sql = "INSERT INTO Vehicle_feature VALUES ('".$_POST['vehicle_id']."', '".$_POST['options'][$i]."')";
    mysql_query($sql);
}