Accordion

[Pro_Luv]

Hi Guys,

I got this accordion that I want to change to be able to insert data into it from the database.. How can I do this ?

The code:

<li class="active firstitem"><a class="closed" href="#">Menu Name</a>
      <ul style="display: none; height: 175px;">
        <li style="display: none;"><a href=#>Item1</a></li>
      </ul>
 </li>

Where I got "Menu Name" I want to load category names in there and where I got "Item1" I want to load the category submenu's in there.

Please Help, I really need help with this

[leatherback]

what specifically are you looking for help with?

• Creating a database?
• Adding fields to the table?
• Database select?
• Processing the resultset?
• Creating the output html

[Pro_Luv]

I want to run a query to select the main category and the sub category's for each main category... Like

//Query to select the main categories
$sql = "Select main From tblcategory";
$r_query = pg_query($conn,$sql);

While ($arr = pg_fetch_array($r_query) {

<li class="active firstitem"><a class="closed" href="#">$arr[0]</a>
}

//Query to select the main category sub menu's
$sql  = "SELECT tblcategory.main, tblcategory.catid , tblsubcategory.submain, tblsubcategory.catid FROM tblcategory";
$sql .= " INNER JOIN tblsubcategory ON tblsubcategory.catid  = tblcategory.catid";
$sql .= " WHERE tblcategory.active=true";
$r_query = pg_query($conn,$sql);

While ($arr = pg_fetch_array($r_query) {

 <ul style="display: none; height: 175px;">
        <li style="display: none;"><a href=#>$arr[2]</a></li>
      </ul>
 </li>
}

I want to group the sub menu's with the right main category like..

*Home
Tables
Chairs

*Electronics
TV
Toaster