Y tak bole access my thread previously...(insert multiple row)

[emnieysh]

Y saya dah tak bley access my previous thread dlm forum ni...
and can sumone plz help me regarding post array in multiple row??
need to present dis 17 april..really need sumone coz i've stuck with dis prob bout a month...

the quest:
can we post array value to next page and add the value to sql??
if can how should i do??
plz.....

[afroman]

Originally Posted by emnieysh

for example :

i have 2 student

Hasanah TT074921 5(marks)
Syakirah TT074318 4(marks)

*marks was a textbox fill..went i insert mark n submit it,
only Syakirah TT074318 4 was insert into db..so how should i do to insert HASANAH n SYAKIRAH record in db..

a few methods can be used. but easiest is to use array.

<input type="text" name="student[1]"...
<input type="text" name="mark[1]"...

<input type="text" name="student[2]"...
<input type="text" name="mark[2]"...

in the action script..

$student = $_POST['student'];

foreach ($_POST['mark'] AS $i => $v) {

    mysql_query("INSERT INTO table VALUES ('%s', %d)", $student[$i],  $v);
}

btw, fine=elok/baik, find=jumpa/cari...