Select and Inserting multiple data into

[aaadee]

Hi, i have a problem with multiple rows, selecting and inserting them into a page, and then to the databases.

it is being taken from the database so i have the code as

while ($row = mysql_fetch_array($sql_result))

so it selects how many rows there are.

then i have two <select><option> drop down lists.

one for Ability, 1 - 6 and one for System, Character - Java - Both.

I want to then submit the page, and SELECT all of them rows and insert them ALL into a database.

so far all it does it inserts the bottom row of the page, on every occasion i do it.

How can i get it to insert all of the rows into multiple insert statements

Cheers

Adam

[bastien]

If you are talking about select boxes with a MULTIPLE option (to choose more than one item), then the entire set is passed as an array (if you pass the data through the url via the get method) you can see that the select box name has several variables in it...

you probably want to explode the array to get distinct values to place each record in the DB in a single row...

$skills = explode(",", $selectboxname);
for each ($skill as $myskill){
$sql = "insert into mytable values(id, $myskill)";
$result = mysql_query($sql,$conn);
}

hth

bastien