[samot]

Hello all,
I am a little stuck on this code. I was able to list all of my images and SUB-categories. But the result is not pleasing. It shows double....

Like this...
Maincategory
...img1.jpg
...Subcat1

...img1.jpg
...Subcat2

...img2.jpg
...Subcat1

...img2.jpg
...Subcat2

and etc...

Here is my code:

PHP Code:

if(isset($_POST['id']) || isset($_GET['id']))

{

    $id = ( isset($_GET['id']) ) ? $_GET['id'] : $_POST['id']; 

    $id = htmlspecialchars($id);

    //

$sql = "SELECT c.cat_id, c.cat_name, c.cat_parent, p.img_id, p.img_file, p.img_thumb, p.img_cat

                FROM ". CATEGORIES_TABLE . " as c," . IMAGES_TABLE . " as p

                WHERE p.img_cat = '$id' AND c.cat_parent = '$id'"; 

        $result = dbQuery($sql) or die(dbError());



    if(dbNumRows($result) > 0 )

    {

        while($row = dbFetchArray($result))

        {

            $u_view_thumb = "index.php?cmd=adm&exe=admin&show=album&get=image&img=view&id=".$row['img_id'];

            // setup images    

            $image_listing = DIR_PATH . $row['img_thumb'];    

            

            // sub categories listing

            $subcat_listing = $row['cat_name'];

            

            $template->assign_block_vars('image_listing', array(

                        'IMAGE_LISTING' => $image_listing,

                        'SUB_CATEGORIES' => $subcat_listing,

                        'U_VIEW_THUMB'=> $u_view_thumb  ));    

        }

    }

    else

    {

        $display_msg = "THERE'S NO IMAGE IN CATEGORY";

    }

} 

All I want to do is list all of the images and sub categories.
Help is appreciated.
Thanks you,
Samot