MySQL HIBA!
Parancs: SELECT
cms_site_partners_hotelads.name,
`desc`,
cms_site_partners_hotelads.shortcut,
cms_site_partners_hotelads.id,
city, rating
FROM cms_site_partners_hotelads
,cms_site_partners_hotelads_categs
,cms_site_partners_hotelads_options
WHERE 1 AND cms_site_partners_hotelads.enabled = '1'
AND cms_site_partners_hotelads_options.hid = cms_site_partners_hotelads.id
AND (cms_site_partners_hotelads_categs.optid IN () AND cms_site_partners_hotelads_categs.hid = cms_site_partners_hotelads.id)
GROUP BY cms_site_partners_hotelads.name, cms_site_partners_hotelads.city ORDER BY mod_date DESC, add_date DESC, id DESC
Hibaüzenet: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND cms_site_partners_hotelads_categs.hid = cms_site_partners_hotelads.id)
' at line 17
MySQL HIBA!
Parancs: SELECT
cms_site_partners_hotelads.name,
`desc`,
cms_site_partners_hotelads.shortcut,
cms_site_partners_hotelads.id,
city, rating
FROM cms_site_partners_hotelads
,cms_site_partners_hotelads_categs
,cms_site_partners_hotelads_options
WHERE 1 AND cms_site_partners_hotelads.enabled = '1'
AND cms_site_partners_hotelads_options.hid = cms_site_partners_hotelads.id
AND (cms_site_partners_hotelads_categs.optid IN () AND cms_site_partners_hotelads_categs.hid = cms_site_partners_hotelads.id)
GROUP BY cms_site_partners_hotelads.name, cms_site_partners_hotelads.city ORDER BY mod_date DESC, add_date DESC, id DESC LIMIT 0,10
Hibaüzenet: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND cms_site_partners_hotelads_categs.hid = cms_site_partners_hotelads.id)
' at line 17