Jump to content

Archived

This topic is now archived and is closed to further replies.

sinisnap

Need some general guidance on creating sub-nav

Recommended Posts

Hi

This 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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.