sinisnap Posted September 3, 2006 Share Posted September 3, 2006 HiThis is my first post, so please be kind...I'm trying to build a sub-nav that lists all volumes in one table but they need to be grouped according to their publishing date id's with a header for each group stating the respective publishing date. in the end it should look like this:[img]http://www.sinisnap.com/subnav.gif[/img]i got the basic mysql query right, i believe and it goes like this:[code] $result = @mysql_query( "SELECT title, date FROM volume, pubdate WHERE volume.pdid = pubdate.id ORDER BY pubdate.id"); if (!$result) { exit('<p>Error fetching volume details: ' . mysql_error() . '</p>'); }[/code]however, i'm not sure how to proceed from there..anyone able to/care to give me some pointers on how to approach this? thank you!jarin Link to comment https://forums.phpfreaks.com/topic/19568-need-some-general-guidance-on-creating-sub-nav/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.