update and delet record
Originally Said By: Ray Borduin
Please attach copies of the pages you are working on instead of copy/pasting their content. That way I can open them in Dreamweaver. Also, please post once per issue instead of combining two pages, so we can both keep track of what we are talking about.For the update page you shouldn't have bound a value for the ID field... this line should be deleted:
$UpdateQuery->bindColumn("ID", "i", "".($termineedit->getColumnVal("ID")) ."", "WA_DEFAULT");
You aren't updating the ID... it stays the same.
Your recordsets on both pages aren't filtered. Don't even try to update or delete the record before you can link to it and display it on both pages.
The Delete page it looks like you don't have a value specified for the lookup value. If you link to the page like: deletepage.php?ID=1
Then you should be filtering the recordset with <?php echo($_GET["ID"]); ?>
And then you should use that same value as the lookup value for your update and delete.
Hello,
Thanks for the quick response - I've tried to follow your instructions, unfortunately I'm not a programmer and therefore have these difficulties. When I filtered the ID, this error message came up:
SELECT * FROM Dates LIMIT -1,1
You have an error in your SQL syntax; MySQL server version for the right syntax to use near '-1,1' at line 1
and the page was no longer displayed or the ids were not counted. I admit that I'm overwhelmed by totol. I send by mail the Dreamweaverseiten, because I do not know how I could send the files otherwise ..... maybe you can help me yes. I'll probably put the wrong values in the tables.
