Web Hosting Forum | Lunarpages


*
Welcome, Guest. Please login or register.
Did you miss your activation email?


Login with username, password and session length
May 21, 2012, 04:35:14 AM

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: Errors with Master Details Page Set using PHP, MySQL & D  (Read 1018 times)
tommorine
Newbie
*
Offline Offline

Posts: 3
« on: June 16, 2004, 07:28:43 PM »
I'm using Dreamweaver MX 2004 and have created a MySQL database that I can connect to. I have 2 pages, the first one I insert a Master Details Page Set and have the ID record open up the second page with the complete details of that perticular record. The first page displays just fine, but when you click on the ID to open the second page, it displays the following error... "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 'index = 4 LIMIT 10, 10' at line 1" The url is http://www.volumedia.com/test.php. Any help would be greatly appreciated.
Logged
tommorine
Newbie
*
Offline Offline

Posts: 3
« Reply #1 on: June 17, 2004, 05:22:56 PM »
I got it all fixed... I re-configure the database to use a timestamp as a reference as opposed to a auto-generating incremental number. It works perfectly... Thanks anyways...
Logged
TranzNDance
Princess of Naboo
Berserker Poster
*****
Offline Offline

Posts: 11809



WWW
« Reply #2 on: June 17, 2004, 05:38:37 PM »
Do you have a primary key for the table? The primary key should be set to auto-increment, and if I understand your use of the word, it should be used as the reference.
Logged
Grr..!! Luff Ya Grr..!! Luff Ya Grr..!! Luff Ya
tommorine
Newbie
*
Offline Offline

Posts: 3
« Reply #3 on: June 17, 2004, 08:21:59 PM »
I did have an autoincrement number set as the primary key... Then I changed it to the timestamp. It increments itself and it works just fine so I think I'll be using that, It would have been nice to figure out why the auto incremental integer didn't work though. I guess it will remain a mystery until the next time I need to set up another Master Details Page Set. Thanks!
Logged
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: