Hello all,

I send people to a page where they can update a record in my MySQL database. I specify which record the page will be set to update by passing a variable (e.g. ...php?tid=4). The actual updating itself works well, however, when I try to redirect them to another page using the "After updating:go to:" where it is set to --- "manage_website.php?sid=" . $row_getSite['sid'] . " --- the script fails to redirect them properly... basically I get a "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1" error and a goofy URL (www.website.com/cms/manage_website.php?sid=&tid=4) - it seems to remember my old query string and puts that in place of the value I want it to pass back via sid.

Any ideas?

Edited by - mkorsmo on 11 Aug 2004 18:06:33

Edited by - mkorsmo on 11 Aug 2004 18:07:06