Jump to content


Photo

Need some general guidance on creating sub-nav


  • Please log in to reply
No replies to this topic

#1 sinisnap

sinisnap
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 03 September 2006 - 12:06 PM

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:
Posted Image

i got the basic mysql query right, i believe and it goes like this:
  $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>');
  }

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





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users