I have created an update form which is all working as the fucntions its self . But i have a problem with selecting the data to update . I have created a drop down menus that populates from mysql but i need the drop down menu to show the selected value of the partulcar record
Code: Select all
<? echo $rows['animalid']; ?>Code: Select all
Code:
select name="animalid">
<?
$query=("select * from animals");
$result=mysql_query($query) or die ("Unable to Make the Query:" . mysql_error() );
while($row=mysql_fetch_array($result)){
echo "<OPTION VALUE=".$row['animalid'].">".$row['animal']."</OPTION>";
}
?>Any help would be grateful Thanks