RE: [PHP-DB] arranging folders hiearchy
| From: | SP | Date: | Sun, 09 Jun 2002 00:29:55 +0000 |
| Subject: | RE: [PHP-DB] arranging folders hiearchy | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19699@lists.php.net to get a copy of this message | ||
Wrong: 10 7 ' 1 3 10' 'Repairs'
Correction: 10 3 ' 1 3 10' 'Repairs'
-----Original Message-----
From: SP [mailto:internetracer@yifan.net]
Sent: June 8, 2002 8:09 PM
To: php-db@lists.php.net
Subject: [PHP-DB] arranging folders hiearchy
I am trying to arrange the results by PATH but within each of the same PATH
section I want it to be arranged by NAME alphabetically so it looks like the
following below. I've tried a bunch of order by's but not getting it to
work.
Is this possible to do? Or do I have to change my PATH data some how.
Home
About Us
Contact Us
Products
Cabinets
Furnitures
Services
Repairs
Waxing
ID PID PATH SECTION
== === ========================== =================
1 1 ' 1' 'Home'
2 1 ' 1 2' 'Products'
3 1 ' 1 3' 'Services'
5 2 ' 1 2 5' 'Furniture'
6 2 ' 1 2 6' 'Cabinets'
7 3 ' 1 3 7' 'Waxing'
10 7 ' 1 3 10' 'Repairs'
11 1 ' 1 b' 'Contact Us'
12 1 ' 1 c' 'About Us'