How to show category name

[shop73]

I have an table with this fields: cat_id, cat_parent_id and cat_name. I have vertical menu with this items! When I click menu items Audio I have "sample.php?c=1" etc...

Example:

cat_id cat_parent_id cat_name
1 0 audio
2 0 video
3 1 sound
4 2 video spot

I tried with recordset:

SELECT *
FROM multimedija
WHERE multimedija.cat_id = colname
ORDER BY cat_name ASC
-------------------------------------
colname = colname, 0, $_GET['c']
-------------------------------------

This show only one category, but I want to show main category (audio) and subcategory (sound) in same page!?

Help!

 

[shop73]

PHP and MySQL

 

[ChrisHirst]

WHERE multimedija.cat_id = colname
 OR 
multimedija.cat_parent_id = colname

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.