[thelist] Mysql query question

PeterV peter at poorbuthappy.com
Mon Oct 7 13:14:01 CDT 2002


Hi,
Mysql throws an error with this query:

select to.name as name, to.id as id FROM xfml_occurrence oc, xfml_page
pa, xfml_topic to WHERE oc.map_id = 10 AND pa.map_id = 10 AND to.map_id
= 10 AND pa.url = '/prototype/multiplefacets.php?mapid=10' AND
oc.page_id = pa.id AND oc.topic_database_id = to.id

Error:
You have an error in your SQL syntax near 'to WHERE oc.map_id = 10 AND
pa.map_id = 10 AND to.map_id = 10 AND '

I can't find what's wrong with it? Any ideas on where to start looking?>
Peter





More information about the thelist mailing list