Will the update statement work under the mysql prompt?
----- Original Message -----
From: "Vladimir Kravtsov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 12, 2001 8:39
Subject: Table won't update
The table sitesats won't update and shows no errors! (even though there are
two instances of echo(mysql_error()))
<html>
<body>
<?php require('../common.php');
if (!isset($areview)) {
echo("You must review the site"); } else {
if (!isset($apositive)) {
echo("You must review the site"); } else {
if (!isset($anegative)) {
echo("You must review the site"); } else {
connectdb();
mysql_select_db(xtopsites);
$sql = "update sitesats set arate='$arate', areview='$areview',
apositive='$apositive', anegative='$anegative', validated='2' where
id='$id'";
$query = mysql_query($sql);
echo(mysql_error());
if (!$query) {
echo(mysql_error());
} else {
echo("Review stored successfully."); }
} } }
?>
</body>
</html>
Any ideas?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
