Hi,
> 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>
Did you try to place the echo(mysql_error()) BEFORE your query? Perhaps
a mysql-error occurs with connectdb() or mysql_select_db ...
Bye,
Thomas Karcher
---------------------------------------------------------------------
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
