Insert multiple values into a table (Split from: LIST/MENUS with multiple selection)

[amoresry]

hi im using php and mysql. On my html page, i dont know how to insert a multiple selection into a table, please help me out. i.e a student selects upt to 5 supervisors as his choice how do i insert the 5 choices for student id 1000 in a table


In the database table this is how its should be:

tbl_allocating
Alloc_id | student_id | supervisor_id | allocated_flag
1 1000 2000 NULL
2 1000 2001 NULL
3 1000 2005 NULL
4 1000 2015 NULL
5 1000 2004 NULL
6 1001 2001 NULL

many thanx
Amor

[r937]

how do i insert the 5 choices for student id 1000 in a table

like this --

insert into tbl_allocating
 ( student_id , supervisor_id )
values 
 ( 1000 , 2000 )
,( 1000 , 2001 )
,( 1000 , 2005 )
,( 1000 , 2015 )
,( 1000 , 2004 ) ;

[amoresry]

hey r937 thanx for your help i will try that..

[amoresry]

how do i submit my selected options from a selection list to another page without highlighting them