На кастом галерее вывести тумбы спонсора по ИД
Posted: Fri Mar 15, 2013 11:10 am
В темплейте кастом галеры запись вида <thumb sponsor_id=<!--SPONSOR_ID--> num=1-10></thumb> вместо тумб данного спонсора показывает ошибку
Mysql error: 1064 (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 '-1, # queryitems' at line 1) in query SELECT DISTINCT(g.id), g.gallery_md5, gs.total_shows as thumb_casts, gs.total_clicks as clicks, if (gs.total_shows < 20, 1, 0) as new_thumb from rot_galleries as g join rot_gallery_stats as gs on gs.thumb_id = g.id join rot_gal2group as g2gr on g.id = g2gr.gal_id WHERE g.status = 1 AND g.rgroup != 0 and g2gr.group_id IN (4) ORDER BY new_thumb ASC, gs.total_ctr DESC LIMIT -1, # queryitems.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/home/xxx/domains/xxxx/public_html/scj/includes/db_modules/mysql.php on line 240
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/home/xxx/domains/xxxx/public_html/scj/includes/db_modules/mysql.php on line 236