Php layer menu

Hello,
I am trying to do search based on layer menu.

let say there are 4 list menu

  1. subject
    2.learning area
  2. topic
  3. learning outcome

whenever users click subject, all learning areas that has the selected subject as parent will appear.
when users select specific learnigng area, all topics that has the selected learningarea as parents will appear. the same things applied to topic and learning outcome.
All the data are from one table- syllabus
( lft, rgt and groups are not used here- it is another purposes)
name and parent are needed I think.
ANy suggestion?
I guess it is like this…
'select name from syllabus where parent=‘the selected item’
but I do not know to do it properly.
thanks for any inputs

CREATE TABLE IF NOT EXISTS syllabus (
ID int(11) NOT NULL,
name text NOT NULL,
lft int(11) NOT NULL,
rgt int(11) NOT NULL,
groups int(11) NOT NULL,
parent text NOT NULL,
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


– Dumping data for table syllabus

INSERT INTO syllabus (ID, name, lft, rgt, groups, parent) VALUES
(1, ‘Overview of Information and Communication Technology (ICT)’, 4, 5, 4, ‘Introduction to Information and Communication Technology’),
(2, ‘ICT In Everyday Life: Education, Banking, Industry and Commerce’, 6, 7, 4, ‘Introduction to Information and Communication Technology’),
(5, ‘Computer Ethics and Legal Issues Definition’, 10, 11, 4, 'Computer Ethics and Legal Issues '),
(6, ‘Privacy’, 12, 13, 4, 'Computer Ethics and Legal Issues '),