Posted by FatCoin on 12/08/05 16:57

Hi.
I had one table organized like

entry_id (int)
parent (int)

so i need to create menu from database.
Every entry that parent = 0 is topmost level of menu. Every entry that
has no child is article.
I write recursive function that fetch rows but I need to test every row
in db, so if any of you know how to fetch only that rows that has
children (other row parent is row id).

Also, it would be great if is MySQL 4 (but any solution is great)
compatible.

Thanx.

• Next in forum: Fetching rows comparing values in same table
• Prev in forum: Fetching rows comparing values in same table
• Thread view: Fetching rows comparing values in same table

[Reply to this message]