I am 3rd yr college student and enrolled to a subject web programming and right now i am developing a web based tabulation for scoring contestants. i am having a trouble regarding on how to update a record(score) in database when the judge is giving a score to the contestant using a textbox and a button .. the problem is that it didnt read the value from an inputed textbox
btw the textbox and the button was inside a do while loop so everytime a new contestant was added the image will be retrieved and another textbox and button will be placed..(to sum up, every contestant has a button and textbox for inputing the score) HERE IS THE CODE..
--------> Do while for retrieving image and textboxes
do{
$count++;
echo "<td style='color:#C90;font-weight:bold;font-size:12px;' >";
echo "<div id = 'hover'>";
echo "<img src = 'images/" . $result['imagename'] . "' height='300px;' width='300px;' class='img'>";
echo '<br/>';
echo $result['Name'];
echo '<br/>';
echo $result['course'];
echo '<br/>';
echo $result['branch'];
$ID = $result['ID'];
echo $result['ID'];
echo '<div class = "hover">';
echo "<form method='post' style='position:relative; bottom:-120px; right:-50px;'>";
echo "<table>";
echo "<tr>";
echo "<td>";
echo "SCORE";
echo "</td>";
echo "<td>";
echo '<input type="text" name="txtscore" style="height:30px; width:50px; background-color:#923227; box-shadow:1px 1px #FFF; color:#C90;font-weight:bold; font-size:16px;"/>';
echo "</td>";
echo "<td>";
echo "</td>";
echo "</tr>";
echo "</table>";
echo "</form>";
echo "<a href = 'fasttrackscw.php?id=".$ID."'>";
echo "<input type='submit' name='btn1'>";
echo "</a>";
echo '</div>';
echo "</div>";
echo "</td>";
$result=mysql_fetch_assoc($query);
if($count >= $max){
//reset counter
$count = 0;
//end and restart
echo "</tr><tr>";
}
}
while($result);
--------> Query for updating
if(isset($_POST['btn'])){
@$id =$_GET['id'];
$sql = "update tblfastracks set casualwear = '$_POST[txtscore]' where contestantid = '$id'";
mysql_query($sql,$connection);
}