Inserting multiple value from <input> to a table in PHP/MySQL

[JPhilS]

Hi to all Webmaster!
I have discover this problem when I inserted the scores of the students i a centain subject.

I am making a school project with regards to saving students' record.

first, I have to view all students under the certain subject and at the last field, I putted a form to put the scores of each student.

say '<input type=text name='score' size=10>' and number of '<input type=text>' is equal to the number of students.
I use the primary key of the students(IdNo) to be inserted at in the first field of the table(studScore).
this is the problem, i want to insert the score of each student from the '<input>' in the second field of the said table.
I am thinking that maybe it deals with array, but i really don't know how to formulate it.

The solution to this problem would be my key in finishing this project.

Anyone?

Thanks in advance.

God Speed!

heres my sample code:

////ADDING SCORE
$addscore=$_GET['score'];
if($addscore){
?>
<table border=1 bgcolor=#E7EBED width=829>
<form action='<? PHP_SELF; ?>' method=post>
<tr align=center>
<td colspan=8><font face="Tahoma" size="2" color=00000><b> Result/s</b></font> </td>
</tr>
<tr align=center>
<td colspan=8>&nbsp;</td>
</tr>
<?
}
$control=$_GET['subControl'];
$result = mysql_query( "SELECT students.IDNO,students.FIRSTNAME,students.LASTNAME ,students.MI,students.GENDER,students.COURSE,stude nts.YEAR FROM students,subjects,subjecttrans WHERE subjects.SUB_CONTROL=subjecttrans.SUBCONTROL AND subjecttrans.SUBCONTROL='$control' AND subjecttrans.IDNO=students.IDNO ORDER BY students.LASTNAME" ) or die ("SELECT Error: ".mysql_error());
$num_rows=mysql_num_rows($result);
//start if
if($num_rows > 0){
?>

<tr>
<th><font face="Tahoma" size="2" color=CC3300><b>Id No.</b></font> </th>
<th align=center><font face="Tahoma" size="2" color=CC3300>Students' Name</b></font> </th>
<th><font face="Tahoma" size="2" color=CC3300>Gender</b></font> </th>
<th><font face="Tahoma" size="2" color=CC3300>Course</b></font> </th>
<th><font face="Tahoma" size="2" color=CC3300>Year</b></font> </th>
<th><font face="Tahoma" size="2" color=CC3300>Add Score</b></font> </th>
</tr>
<tr align=center>
<td colspan=8>&nbsp;</td>
</tr>
<form action="<? PHP_SELF; ?>" method=post>

<? $i=0;
while ($i < $num_rows) {

?>
<tr height=15 class=off onmouseover="this.className='on'" onmouseout="this.className='off'">

<?

$id=mysql_result($result,$i,"IDNO");
$fn=mysql_result($result,$i,"FIRSTNAME");
$ln=mysql_result($result,$i,"LASTNAME");
$mi=mysql_result($result,$i,"MI");
$gen=mysql_result($result,$i,"GENDER");
$cors=mysql_result($result,$i,"COURSE");
$yer=mysql_result($result,$i,"YEAR");
?>
<td>&nbsp;<font face="Tahoma" size="2" color=666622><? echo $id; ?></font></td>
<td align=left>&nbsp;<font face="Tahoma" size="2" color=666622><? echo strtoupper($ln.","." ".$fn." ".$mi); ?> </font> </td>
<td>&nbsp;<font face="Tahoma" size="2" color=666622><? echo substr($gen,0,1); ?></font></td>
<td>&nbsp;<font face="Tahoma" size="2" color=666622><? echo strtoupper($cors); ?></font></td>
<td>&nbsp;<font face="Tahoma" size="2" color=666622><? echo strtoupper($yer); ?></font></td>
<-----this is the '<input>' i've tried to explain----->
<td>&nbsp;<font face="Tahoma" size="2" color=666622><input name="score" type="text"></td>


<?

$i++;


}

?>
</tr>
<tr height=20>
<td colspan=8 align=center>&nbsp;<font face="Tahoma" color=666666 size="2">****Nothing Follows****</font></td>

</tr>
<tr>
<td align=right>&nbsp;</td>
<td align=right>&nbsp;</td>
<td align=center><input size=40 type="submit" value="Save Checking" name="add" class="submit" /></td>
</tr>
</form>

</table>

[harshmaul]

Hi,
Firstly next time you post please use code tag blocks it makes it easier for me to diagnose and help...

now possible solution,

If you want to assign the value of the score to a input text box you need to do something like this....

<?php
$score = 10;
//but instead of 10 you calculate the score
?>
<input name="score" type="text" value="<?php echo $score ?>">

hope that helped