please help me in php...?

  • Thread starter Thread starter mark neil l
  • Start date Start date
M

mark neil l

Guest
i can display my data in php but i cannot update the record into my sql

this is my codes on how to display records
please help me on how to edit data and update... thx


<?php
$search = $_GET[id_num];
mysql_connect("localhost", "dbsam", "dbsam") or die(mysql_error());
mysql_select_db("db") or die(mysql_error());

$result = mysql_query("SELECT * FROM tblstudent_info WHERE Id_number='$search'") or die(mysql_error());

$row = mysql_fetch_array( $result );
$result1 = mysql_query("SELECT * FROM tblstudent_grade WHERE Id_number='$search'") or die(mysql_error());

echo "<form id='form1' method='post' action=''>";
echo "<table align='center' width='100%' border='2' cellpadding='0' cellspacing='0'>";
echo "<tr><td width='145' height='29' valign='top'><div align='center'><H5>Sugject Code</H5></div></td>
<td width='300' valign='top' class='style3'><div align='center'><H5>Description</H5></div></td>
<td width='45' valign='top' class='style3'><div align='center'><H5>Units</H5></div></td>
<td width='45' valign='top' class='style3'><div align='center'><H5>Grade</H5></div></td>
</tr>";

while($row1 = mysql_fetch_array( $result1 )){

$result2 = mysql_query("SELECT * FROM tblsubject WHERE Subject_Codes='$row1[Course_Code]' and Courses='$row[Course]'") or die(mysql_error());

$row2 = mysql_fetch_array( $result2 );

echo "<tr><td>".$row2['Subject_Codes'];
echo "</td><td>".$row2['Description'];
echo "</td><td><div align='center'>".$row2['Units'];
echo "</td><td><div align='center'><input id='gra' name='gra[]' value='$row1[Grade]' maxlength='3' size='3' style='text-align:center'/>";
echo "</div></td></tr>";
}

echo "</table>";
echo "<div>";
echo "<p>";
echo "<input type='submit' name='submit' value='Update' id='submit'/>";
echo "</p>";
echo "</div>";
echo "</form>";
?>
 
Back
Top