outline .... need help
| From: | Larry \"RedCobra\" Linthicum | Date: | Thu, 27 Sep 2001 22:13:09 +0000 |
| Subject: | outline .... need help | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-12804@lists.php.net to get a copy of this message | ||
I want to store, retrieve, and print out an "outline" dynamically
I. Heading
A. Subheading
1. detail
2. second detail
B. Second Subheading
II Second Heading
III Third Heading
A.sub
B Sub
etc etc I do not know, in advance, how many entries there will b, in any
given place. And, it must be possible to ADD new entries, AND have it
print in the correct order
I have a fair amount of experience with PHP / MySql for simpler
applications, but every way I can think of to do this seems much more
complicated than seems right. I'm hoping some of you have ideas on how to
set up the tables, and how to retrieve and print the data. Links to
examples or tutorials will be greatly appreciated .... I've searched the
sites I know of, but found little that addresses my problems.
My poor head is a buzz with questions, <G>
For instance, what kind of sort field can I use that will allow a "heading"
to be inserted between "I" and "II " and then displayed in the correct
order? Or, is there a way to retrieve ALL the "detail" level entries with
one query, then sort them and print them un the right heading or will I
have to do a long series of queries ... I'm nearly certain I'm making
it more difficult than it is.... thanks for your help and suggestions