SQL to generate a treeview

CodeCharge Studio

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

SQL to generate a treeview

Author

Message

mutsch

Posted: 10/16/2002, 12:04 PM

Hi chargers,

i want to create a forum overview grid that shows all forum entries in a hierarchy. Is there a way to define a sql statement that returns the records in the right sequence? The hierarchy can be of any depth, i.e. you can answer to the orig. posting and to answers of the posting, aso.
Is there anyone who can solve this problem, i am not an sql expert. Thanks.

mutsch

Posted: 10/16/2002, 12:14 PM

one more thing: i am using MySQL with PHP

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home | Search | Members | Register | Login