Click here to Skip to main content
15,889,462 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I want to update marks of a particular student in particular subject out of eight subjects. please inspect the following code.
PHP
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.
Posted
Updated 21-Jan-13 5:35am
v2

1 solution

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

Danny
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900