Please login or register.

Login with username, password and session length
Advanced search  


You need/want an older version of sNews ? Download an older/unsupported version here.

Author Topic: MySQL categories tree - don't know how to select nodes and stuff  (Read 3680 times)


  • Newbie
  • *
  • Karma: 0
  • Posts: 48

Hi people,

I'm having a little trouble, as in:

Considering mysql table categories (id, id_cat, categorie)

where: id = the unique id of each category,
           id_cat = the id of the parent category for a given (sub)category (if id_cat = 0 then this is a root category),
           categorie = the text holding the name of the category

How can i grab and display these in a html