Programmers out there ..help me please ....
here is the story..
i'm taking out some data from mysql database into a combo box so that user can select which data they want to edit.
the problem here is as i am using the while loop to load the data into the combo box the value for the variable is the value of the last item loaded.
here is the codes:
$query2=mysql_query("select * from suggestion");
<form method='post' action='evaluate.php'>
select suggestion to evaluate : <select name='feasibility'>";
echo"<option value='$sid'>Keyed in by $coordinator At $date</option>";
<input type='submit' name='submit' value='submit !!'><br><BR>
the problem is the $sid variable is holding the id of the las item loaded.
so... somebody please help me..
please whow me if there is another way to do this. cry.gif cry.gif cry.gif