Can someone help me with this MYSQL error please

[brizzad]

mySQL query error: SELECT s.*, t.template, c.css_text
FROM brizzad_skins s
LEFT JOIN multiforums_templates t ON (t.tmid=s.tmpl_id)
LEFT JOIN multiforums_templates c ON (s.css_id=c.cssid)
WHERE s.default_set=1

mySQL error: Unknown column 'c.css_text' in 'field list'
mySQL error code: 
Date: Friday 10th of June 2005 05:31:13 PM

Can someone please explain to me what that means, and how I can fix it? Thanks

[woj]

css_text column doesn't exist in multiforums_templates

you also have 'multiforums_templates' in the LEFT JOIN statement twice, that might be the problem...

[brizzad]

Originally Posted by woj

css_text column doesn't exist in multiforums_templates

you also have 'multiforums_templates' in the LEFT JOIN statement twice, that might be the problem...

thanks man, that put me on the right track