links.link_category = $link_cat"; $cat_name = $wpdb->get_var("SELECT $wpdb->linkcategories.cat_name FROM $wpdb->linkcategories WHERE $wpdb->linkcategories.cat_id = $link_cat"); if (!empty($cat_name)) { $cat_name = ": category $cat_name"; } } } ?> links.link_url, link_rss, $wpdb->links.link_name, $wpdb->links.link_category, $wpdb->linkcategories.cat_name, link_updated FROM $wpdb->links JOIN $wpdb->linkcategories on $wpdb->links.link_category = $wpdb->linkcategories.cat_id AND $wpdb->links.link_visible = 'Y' $sql_cat ORDER BY $wpdb->linkcategories.cat_name, $wpdb->links.link_name \n"; //echo(""); $prev_cat_id = 0; $results = $wpdb->get_results($sql); if ($results) { foreach ($results as $result) { if ($result->link_category != $prev_cat_id) { // new category if ($prev_cat_id != 0) { // not first time ?> link_category; } // end if new category ?>