[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