build menu with mysql data
| From: | Marc Bleuler | Date: | Tue, 21 Jan 2003 17:31:15 +0000 |
| Subject: | build menu with mysql data | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-general+get-132464@lists.php.net to get a copy of this message | ||
Hi,
I would like to bild a tree menu with mySQL data. where I have the collapsed
main menue and when I click the link the specific submenue expands (as
follow).
(collapsed Main Menu)
+ Home
+ Downloads
+ About me
+ Search
....and for example if I click the "Download" section it will look as
follow....
(expanded Main-Sub Menu)
+ Home
+ Downloads
- Music
- Programm
+ About me
+ Search
....and the SQL Tables...
MAINMENUE_TABLE
ID NAME
-----------------------------
| 1 | Home |
| 2 | Downloads |
| 3 | About me |
| 4 | Search |
....and....
SUBMENUE_TABLE
ID MAIN_ID NAME URL
-------------------------------------------------------------------
| 1 | 2 | Music |
./somefile.php?action=music
| 2 | 2 | Programm |
./somefile.php?action=programm
| 3 | 3 | Pictures |
./somefile.php?action=pictures
| 4 | 3 | Address |
./somefile.php?action=address
| 5 | 4 | My Page |
./somefile.php?action=mypage
| 6 | 4 | The Web |
./somefile.php?action=theweb
| 7 | 4 | Google |
./somefile.php?action=google
If I'm using a while loop it won't work, so I realy don't have and more
ideas...
Please consider in your explanations I'm a PHP beginner... :-)
thanks
Marc