Re: Table won't update

2001-06-12 Thread Thomas Karcher
Hi, > The table sitesats won't update and shows no errors! (even though there are > two instances of echo(mysql_error())) > > > > if (!isset($areview)) { > echo("You must review the site"); } else { > if (!isset($apositive)) { > echo("You must review the site"); } else { > if (!isset($anegati

Re: Table won't update

2001-06-11 Thread Rolf Hopkins
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

Re: Table won't update

2001-06-11 Thread Maurice Aubrey
Here are some ideas for an improved debugging methodology. First, take the query that you think should be working, substitute in hard-coded values, and test it through the mysql command-line client interface. So, for example, run the "update sitesats set..." query and use hard-coded values for $