select * from Content where section = (SELECT section from Sections where sectionName = 'Welcome')
SELECT section from Sections where sectionName = 'Welcome'Works fine and returns the value of 1.
select * from Content where section = '1'Works fine and returns the record that I am looking for.
select * from Content where section = (SELECT section from Sections where sectionName = 'Welcome')Gives an error - in the form of this:
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 'SELECT section
WHERE sectionName = 'Welcome' )
I have version 4.0.18 installed, using phpmyadmin 2.5.2 (my host controls these obviously) but surely nested queries work fine in these versions? I read up on them as well, but the syntax is exactly (as far as I can see) identical - so I am wondering if anyone can see anything wrong with their fresh eyes.
The two tables are called:
Sections has section and sectionName as it's fields, section as a tinyint(4), and sectionName as a varchar(50). There is one entry, section = 1, sectionName = Welcome.
Content has a field called section which is also tinyint(4) - the two fields I am matching.
There is one entry (obviously more fields) but the section field is 1... to correspond to the welcome
Really struggling to see what maybe the problem, and hoping (as i said) some fresh or more experienced eyes may see a problem. Thanks for your time
(Oh yeah, am converting my previously working mssql to mysql queries as I swap databases... hence not that familiar with mysql tbh).