Hi All.
Im new in PHP.
I created page and connected it to database. How to update record in database.
<?php
include (\'Connections/dbconn.php\');
$query = "SELECT * FROM TEST";
$result = MYSQL_QUERY($query);
$number = MYSQL_NUM_ROWS($result);
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Update Form</title>
</head>
<body>
<form action="update.php" method="Post">
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<input type="Hidden" name="ID" value="ID">
<?php
while ($row = mssql_fetch_array($result))
{
?>
<tr>
<td width="13%" align="right"><strong>First Name:</strong></td>
<td width="87%"><input type="text" name="FirstName" value="<?php echo $row[\'FName\']; ?>"></td>
</tr>
<tr>
<td align="right"><strong>Last Name:</strong></td>
<td><input type="text" name="LastName" value="<?php echo $row[\'LName\']; ?>"></td>
</tr>
<tr>
<td align="right"><strong>Rec No:</strong></td>
<td><input type="text" name="RNo" value="<?php echo $row[\'RecNo\']; ?>"></td>
</tr>
<? } ?>
</table>
<input name="btnUpdate" type="Submit" id="btnUpdate" value="Update Information">
</form>
</body>
</html>I will appreciate for help.