Quote Originally Posted by safewatch View Post
Ok, so if you look at the new message, it seems that I'm missing the $sortorder variable in the query. I put in "ld.links_title" directly instead of $sortorder and everything works fine. But I see just above the query where the $sortorder is defined, so I don't know why it wouldn't work? Maybe I'll just leave it hard-coded for now.

Code:
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 'limit 0, 20' at line 1
in:
[select l.links_image_url, ld.links_title, ld.links_description, ld.links_title, l.links_id from zen_links_description ld, zen_links l, zen_links_to_link_categories l2lc where l.links_status = '2' and l.links_id = l2lc.links_id and ld.links_id = l2lc.links_id and ld.language_id = '1' and l2lc.link_categories_id = '1' order by limit 0, 20]
Did you set the sort order in admin -> configuration -> links manager ???