dreamweaver repeating table
How to successfully pass a variable from MySQL to "update page" History "with PHP in Dreamweaver?
I making a database of e-for the class. Each table has a page with the list (which shows all the data in the table), and insert page, a page update, and delete the page so you can add, delete and modify records. I passed a variable to the delete page, using the Wizard for the Suppression of Dreamweaver, eliminates fine when I add? id = # at the end of the URL (using the PHP variable to indicate the row), but when I try to do the same update my page, nothing happens. I'm always stuck with the first record of my table. I know I can repeat my area and get them all, but I want to spend the variable over the link URL to be I choose, I can update that record alone. (Sorry if it sounds like a n00b. This is a kind of MySQL and PHP do not really learn outside the use of assistants and the addition of a variable for the end of a link URL.)
Dreamweaver can not code properly for MySQL. The Wizards can not even correctly understanding the MySQL command. DW does not not respect the correct syntax. You will need to edit the commands by hand. Examples: $ sql = "insert into TableName` `(` field1 `,` field2 `) VALUES ( '". $ Value1. "' Value '". $ Value2. "')"; $ Sql = " delete from `TableName` where `field1` = ' ". $." ' ", $ Sql =" UPDATE `TableName` su `field1` =' ". $ Value1. " ',` Field2 `='". $ Value2. " ', Where` field3 `='". $ Value3. " '"; (Adde space for greater clarity, pay attention to investing in single quotes, single quotes and double quotes) PS: It will take less time to learn to learn Php and MySQL Dreamweaver, then learn to correct the mistakes it does!
