PHP query problem...
| From: | Jeff Lewis | Date: | Wed, 10 Oct 2001 19:50:36 +0000 |
| Subject: | PHP query problem... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-70728@lists.php.net to get a copy of this message | ||
I am using PHP to grab several amounts of data from different tables...Having a problem with my
query though :( Can anyone spot what is wrong with it?
The structures are below... What I am trying to do is list every record in gueformat but for site,
section, and subsection I need to also query other tables since the numeric is stored in
gueformat...
Table: gueformat
name - text
site - number
section - number
subsection - number
help - memo
Table: site
id - autonumber
name - text
Table: section
id - autonumber
name - text
Table: subsection
id - autonumber
name - text
So when it prints it prints this:
gueformat.name|site.name|section.name|subsection.name
Query not working:
SELECT gueformat.name AS sutname, site.name, section.name as sectionname, subsection.name as
subname, gueformat.help as helptext from gueformat join site on gueformat.site = site.id join
section on gueformat.section = section.id join subsection on gueformat.subsection = subsection.id