GreenNature.ca offers tips and practices you can implement in your household, school, or community to save our planet.

Green Living Tips

[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