Re: PHP query problem...

print_r() your result. $result = mysql_query($query); print_r($result); see what the index names are classiifed as, are they correct or no ? -- Chris Lee lee@mediawaveonline.com "Jeff Lewis" <jeff@hyrum.net> wrote in message news:014c01c151c4$d6c4b4e0$76a1a8c0@LEWISJCIT... 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