Im trying to make a master detail page in dreamweaver using a database with
id set as unique value and 3 fields, name last name and email varchar.
Im following this guide how to make a master detail page in dreamweaver
http://www.adobe.com/support/dreamweaver/building/master_detail_php/
Everything is working ok until i test the page and i get these error messages
i tested the site both on local server and on my webhost.
tested on local server the page links to detail page but get this message
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 'ORDER BY id ASC' at line 1
Tested on my webhost
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
I use id as unique value in the database and in the url for the links.
I suspect something is wrong in my database/table but not sure since i followed the steps very carefully how to set up the pages in dreamweaver.
I would appreciate some help how to solve this problem which probably lays
in the sql/database since im a beginner at creating tables.
