No valid database connection 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 ')
group by a.item_id, country, item_name, item_type, item_desc,item_ph' at line 31 SQL=SELECT
a.item_id,
case when d.highlighted='Y' then 1 else 9 end as high_light,
case when b.city='' then 1 else 9 end as city,
case when b.country_code='US' then 1 else 9 end as country,
item_name,
item_type,
item_desc,
item_photo_thumb,
item_photo_address,
url_given,
currency,
price,
weblink_url,
market_street_address,
market_postcode,
city
FROM jos_pl_item a
join jos_pl_item_market b
on a.item_id=b.item_id AND (b.country_code = coalesce('US' ,'INF'))
join jos_pl_item_name c
on a.item_id=c.item_id
left join jos_pl_item_content d
on a.item_id = d.item_id and d.content_id='68'
where c.lang='fr'
AND CHAR_LENGTH( c.item_name ) >0
and a.item_id in
()
group by a.item_id, country, item_name, item_type, item_desc,item_photo_thumb, item_photo_address,
url_given, currency,price, weblink_url,market_street_address, market_postcode,city
order by rand()
limit 0,5
Inspiration
La grande faute des éducateurs est qu'ils ne se rappellent jamais assez bien qu'ils furent eux-mêmesdes enfants. Jacques de Lacretelle
Que pensez-vous de ConnectionZen? Ce site vous a-t-il aidé dans votre vie? Combien de personnes sont rentrées dans votre réseau d'amis grâce à notre forum et à notre communauté?