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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.