I want to update marks of a particular student in particular subject out of eight subjects. please inspect the following code.
echo 'Marks Details of '.$id.' in '.$semester.' semester'.'<br>';
$query='SELECT subname,marks
FROM `2-1subjects`
JOIN `2-1`
ON `2-1subjects`.subcode=`2-1`.subcode
WHERE id='."'".$id."'";
$sql=mysql_query($query);
if(!$sql)
{
die('invalid Query:'.mysql_error());
}
Print "<table border=0 cellpadding=10>";
Print "<th>SUBJECT NAME</th>";
Print "<th>MARKS</th>";
while($row = mysql_fetch_array($sql))
{
Print "<tr>";
print "<td>".$row['subname'] . "</td> ";
?>
<td> <input type="text" style="text-align:center" value="<?php echo $row['marks'] ?>" /></td>
<?php
Print "</tr>";
}
Print "</table>";
?>
<form method="POST" action="2-1marks_update.php" >
<input type="submit" name="submit" value="Update Marks"/>';
</form>
<?php
and the below two are my 2-1 and 2-1subjects tables respectively. here 'id' and 'subcode' are primary keys.
id subcode marks
10kp1a1201 2-1sub#5 80
10kp1a1201 2-1sub#4 70
10kp1a1201 2-1sub#3 60
10kp1a1201 2-1sub#2 50
10kp1a1201 2-1sub#1 40
10kp1a1201 2-1sub#6 90
10kp1a1201 2-1sub#7 100
10kp1a1201 2-1sub#8 80
subcode subname credits
2-1sub#1 s1 4
2-1sub#2 s2 2
2-1sub#3 s3 2
2-1sub#4 s4 4
2-1sub#5 s5 2
2-1sub#6 s6 4
2-1sub#7 s7 2
2-1sub#8 s8 2
my question is since i have retrieved 'subname' and respective 'marks' in a table as shown in the above code using the same textbox in a while loop. Now i want to update 2 or 3 subjects according to the context. then how the modified marks along with subject name opposite to it in a table row are passed to another page.
How can i get the subjectname and value of the marks in the textbox from the retrieved table row , such that the updation tesk is depends on this (subname, marks) pair.
please help me. any answer is appreciable. Help me.