I am using a grid and html template to display a document that pulls data from two tables. The primary table contains the content of the document, the secondary table contains information about the author. My SQL statement gets the data from the 1st table - and I added fields to the grid to get data from the 2nd.
The primary key for the 2nd table “address” is autoincrement.
I am getting this error:
Parse error: syntax error, unexpected ‘;’
SQL Builder writes it like this (and it works)
SELECT
name,
site_num
FROM
address
WHERE
(site_id = ‘1’)
If I try to use the exact query to select from the table, it does not work.
If I create a different grid based on only the 2nd table and use this query it works:
SELECT
site_id,
name
FROM
address
WHERE site_id = 1
If I use that query in the select statement of my added field(s) it does not work.
In PhpMyAdmin, this works:
SELECT * FROM address WHERE site_id = 1
I have tried numerous variations of the select statement to get data from that 2nd table using the ‘site_id’ (auto-increment) field and it does not work.
If I use a different field instead of the key field, it works. Seems to me to be an issue with the auto-increment field.