update query not working
| From: | Peter Gumbrell | Date: | Sun, 23 Feb 2003 22:56:55 +0000 |
| Subject: | update query not working | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-136770@lists.php.net to get a copy of this message | ||
I wonder if anyone can see why the following code is not working. this is
taken from a larger functions, the rest of which seems to be working well:
print "<INPUT TYPE=\"Submit\" NAME=\"Submit\"
Value=\"Update\"></td>";
print "<td></td><td></td></tr>";
print "</table>";
print "</form>";
if ($_POST['Update'])
{
print "updated!!";
$rank = $HTTP_POST_VARS['rank'];
$title_new = $HTTP_POST_VARS['titles'];
$query_update = "UPDATE choices_peter SET rank = $rank, workshop_id =
$title_new WHERE choice_ID = $choice_id";
$update = mysql_query($query_update, $link) or die("display_db_query:" .
mysql_error());
}
I do not see the statement "updated!!!" printed, but I cannot see anything
wrong with my syntax. Any help would be appreciated.
Peter Gumbrell
peter@orillia.net