Replies Back to Article

how to look this tutorial or extencion

March 26, 2003 by Peppeto May

RE: how to look this tutorial or extencion

March 27, 2003 by Martha Graham

This is a request, when someone has this extension, they will post it here.

Martha Graham

RE: RE: how to look this tutorial or extencion

April 21, 2003 by michael mr

Tree Menu From Database ( Access/SQL)

September 8, 2003 by iftikhar saifi

Waiting for this Extension. Waiting for this Extension. Waiting for this Extension.

Thankss.

Iftikhar

Re : Create Tree Menu From a Database Query

September 20, 2003 by Dave Lynes

Have a look at

http://www.jsmadeeasy.com/javascripts/Pull%20Down%20Surfing/DHTML%20Script%20-%20Foldoutmenu2/

(watch for line wrap on that link)

I've used that on a commercial site, but I've modified it so that its pulling information from 17 SQL server tables using 3 stored procedures and a little dynamic SQL for some of the nesting. I've not even attempted to convert it into an extension (haven't had the time), but if you take your time and have a basic understanding of what the script does and how it pulls the information onto the page, you shouldn't have to much hassle making a couple of recordsets that:

a) count the number of rows in your recordset

b) display the main categories

c) loop round and display the subcategories based on what the category was

Have fun