category & sub category

[thenotorious_flag]

Hi I have table where i want to display the categories with parent id 0 and When parent id is 1 or 2 and so on...

it should display as :

autos/auto1
autos/cars

Etc:

My database table is like this:

cid int(11) No auto_increment
parentid int(11) No 0
img varchar(30) latin1_swedish_ci No
title varchar(40) latin1_swedish_ci No
cdesc text latin1_swedish_ci No
hits

Currently it is diaplying straight as:

categories
and after finish of main categories .

sub ategories start.

i am using the query as;

select cid, title, parentid
from grcat
order by cid

<cfselect name="category" label="Select Category: " value="cid" display="title" query="getCats" tabindex="1" tooltip="Chooose Your category"></cfselect>

i want is my subcategories should show after their maincategory

like:

autos/car
autos/files

in the same single select.

I trying it but no possible solution working me instead

[Daverms]

Cross Post!!!.


http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1&catid=3&threadid=1409825&ente...