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