Forums

PHP

This topic is locked

Recursive Menu using PhaKT ?

Posted 05 Aug 2001 23:44:24
1
has voted
05 Aug 2001 23:44:24 Bob Costa posted:
Anyone know how I can build a recursive db lookup using phaKT ? This is for a multi-level menu.



Replies

Replied 06 Aug 2001 19:45:33
06 Aug 2001 19:45:33 Tim Green replied:
Yes. All you need to do is to create a recordset as normal, including the parameters from the recursive loop that are going to act as your filter.

Go into code view, and then select all of the relevant code and cut and paste it within the loop that you have created, and it's done.

Word of Warning : Always, but always ensure that if you are performing a recursive search like this, that you also cut the $Recordset->Close() block of code at the end of your file and place this too within the loop too. If you don't you can soon find that you overload your server with connections. Not much of a problem if you own the server, but it can be a major headache if you have to answer to an ISP.

Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>

Reply to this topic