Click here to Skip to main content
11,795,848 members (76,486 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: PHP table Data row
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."'";
  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> ";
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.
Posted 21-Jan-13 4:37am
Edited 21-Jan-13 5:35am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Bump the arrays into session variables, call the second page - retrieve the arrays from the session then zap 'em...


This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Maciej Los 350
1 Sergey Alexandrovich Kryukov 326
2 KrunalRohit 239
3 Andy Lanng 236
4 OriginalGriff 230
0 OriginalGriff 1,852
1 Maciej Los 1,465
2 KrunalRohit 1,300
3 CPallini 840
4 Richard MacCutchan 828

Advertise | Privacy | Mobile
Web01 | 2.8.151002.1 | Last Updated 22 Jan 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100