[insert_php] global $wpdb; $cats = $wpdb->get_results(‘SELECT * FROM green_tips_cat ORDER BY catID’); foreach($cats as $row) { print “catID\”>$row->name
“; } [/insert_php]
A-to-Z list

---

[insert_php] global $wpdb; $cats = $wpdb->get_results(‘SELECT * FROM green_tips_cat ORDER BY catID’); foreach($cats as $row) { print ““; print ‘‘; $items = $wpdb->get_results(“SELECT * FROM green_tips WHERE catID=$row->catID AND `show`=’y’ ORDER BY title”); foreach($items as $item) { print ““; print ““; print ‘‘; } print ‘‘; } [/insert_php]

catID\”>$row->name		[ top ]
	title\”>$item->title
	$item->desc