when i select the student id
the corresponding details of the students should be listed in the test box given
for example
i have given my code down
do help me to solve my problem
[php]
<html>
<head><title>information</title>
</head>
<body>
<form name="input" action="link1.php" method="post">
<table align="center" bgcolor="#eeeeee" border="0" cellpadding="10" cellspacing="10" width="100%">
<tr><td>
No:
<?php
$opt1 = '';
$bb = mysql_query("SELECT * FROM details ");
while ($val = mysql_fetch_array($bb)) {
$opt1 .= "<option value='$val[0]'>$val[0]</option>";
$pr =$val[0];
print_r($pre);
}
?>
<select name="sno"> <?=$opt1?>" ></select>
</td>
</tr>
<tr><td>
Name:
<input type="text" id ='$val->number'readonly='true'name="sstd" value="">
</td>
</tr>
<tr><td>
Standard:
<input type="text" readonly='true'name="sstd" value="">
<br>
</td>
</tr>
<tr><td>
English:
<input type="text" readonly='true'name="seng" value="">
<br>
<br>
</td>
</tr>
<tr><td>
Maths:
<input type="text" readonly='true'name="smath" value="">
<br>
</td>
</tr>
<tr><td>
Science:
<input type="text" readonly='true'name="ssci" value="">
<br>
</td>
</tr>
<tr><td>
Social Science:
<input type="text" readonly='true'name="sss" value="">
<br>
</td>
</tr>
</table>
</form>
<form name="input" action="" method="post">
<a href = "addlink.php">ADD</a>
   
<a href = "viewlink.php">VIEW </a>
   
<a href = "deletelink.php">DELETE </a>
   
<a href = "link4.php">EDIT </a>
</form>
</body>
</html>
[/php]
thanks a mile in advance
2
