Master Detail page Set Problem

Report · Sep 08, 2012

Hi all

I am trying to build a Master Page Detail but having problems

I build the master page ok and let dreamweaver build the result page all looks ok and has the fields etc that I want however when I look at the master page in a browser (12) it goes to the detail page but give me 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 'ID = 1003 LIMIT 0, 10' at line 1

line 1 is

<?php require_once('Connections/Golfers.php'); ?> same as master page I am using XAMPP

Cheers

P.O.I.

Report · Sep 08, 2012

Person Of Interest wrote:
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 'ID = 1003 LIMIT 0, 10' at line 1

The line 1 in the error message refers to the SQL query, not your PHP script. In fact, it's always on line 1 because there's only ever one line in a SQL query.

The MySQL error message always identifies the error as being "near" something. What it actually means is that the error is immediately before that point. So, without the full SQL query, the error message isn't very helpful. Paste the code from the top of the page into this thread so others can examine the SQL.