inserting each item from an array into a database help????

[aron]

here is my array hown can i capture each item within the array and insert it into a database.

<select name="suburbs[]" size="12" m....... (its a multiple selectable list menu)

here is the sql to insert into the database im guessing i need to loop through the array for each item.

$sql_suburb = "INSERT into login_suburbs (login_id,suburb,area)".
"values($user_id, $suburb, $page)" or die("Invalid query: " . mysql_error());
echo "$sql_suburb";
$result_suburb = mysql_query($sql_suburb);

cheers aron.

[pablo_ar]

Build a query with multiple inserts like

insert into table (col_a,col_b) values ('val 1','val 2'),('val 3','val 4')

use a for to run through the array, and an if to test if the index of the array is the last so you don't end the query with a ,

I hope it helps.

[aron]

the array will be like this.
suburb=a&suburb=b&suburb=c&suburb=d&suburb=e&suburb=f

so i just want to count how many there are do a loop and insert each suburb so in the baove there will be 6 loops.

cheers aron.