Thanx all for the help in resolving this deprecated function issue:)
On 1/31/07, Ryan Boren <[EMAIL PROTECTED]> wrote:
On 1/31/07, Joefish <[EMAIL PROTECTED]> wrote: > On 1/31/07, Alex Leung <[EMAIL PROTECTED]> wrote: > > I just realized that I'm getting this error on my Links page: > > http://www.sixsteps.org/links/ > > > > *WordPress database error: [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 '' at line 1] > > SELECT cat_id, cat_name FROM > > > > *** Can anybody shed some light on this? > > (snip) > > I ran into something very similar with a friend. Try changing this: > > $link_cats = $wpdb->get_results("SELECT cat_id, cat_name FROM > $wpdb->linkcategories"); > > into this: > > $link_cats = $wpdb->get_results("SELECT cat_id, cat_name FROM > $wpdb->categories WHERE link_count > '0'"); > > > That modified SELECT worked just fine for my friend, but then we also > needed to tweak the rest of his custom function. Or get_categories('type=link'). That way you are insulated from DB schema changes. Using API instead of SELECTs when possible makes forward compatibility much easier to maintain. Ryan _______________________________________________ wp-testers mailing list [email protected] http://lists.automattic.com/mailman/listinfo/wp-testers
-- Alex Leung more than a name, it's a value--a way of life: "worship with poles." 2 Samuel 6:13 - http://www.sixsteps.org _______________________________________________ wp-testers mailing list [email protected] http://lists.automattic.com/mailman/listinfo/wp-testers
