As I said in another post, I have built a php image gallery using a tutorial found here on sitepoint. The viewgallery.php displays the categories in hard link format accross the top of the page, but I would prefer to have them shown in a dropdown list instead if that's possible, then maybe use the onSelect feature to load the new gallery?

here is the code:

PHP Code:
<?php
    
include("connect.php");

    
// initialization
    
$result_array = array();
    
$counter 0;

    
$cid = (int)($_GET['cid']);
    
$pid = (int)($_GET['pid']);

    
// Category Listing

    
if( empty($cid) && empty($pid) )
    {
        
$number_of_categories_in_row 4;

        
$result mysql_query"SELECT c.category_id,c.category_name,COUNT(photo_id)
                        FROM gallery_category as c
                        LEFT JOIN gallery_photos as p ON p.photo_category = c.category_id
                        GROUP BY c.category_id" 
);
        while( 
$row mysql_fetch_array$result ) )
        {
            
$result_array[] = "<a href='viewgallery.php?cid=".$row[0]."'>".$row[1]."</a> "."(".$row[2].")";
        }
        
mysql_free_result$result );    

        
$result_final "<tr>\n";

        foreach(
$result_array as $category_link)
        {
            if(
$counter == $number_of_categories_in_row)
            {    
                
$counter 1;
                
$result_final .= "\n</tr>\n<tr>\n";
            }
            else
            
$counter++;

            
$result_final .= "\t<td>".$category_link."</td>\n";
        }

        if(
$counter)
        {
            if(
$number_of_categories_in_row-$counter)
            
$result_final .= "\t<td colspan='".($number_of_categories_in_row-$counter)."'>&nbsp;</td>\n";

            
$result_final .= "</tr>";
        }
    }


    
// Thumbnail Listing

    
else if( $cid && empty( $pid ) )
    {
        
$number_of_thumbs_in_row 5;

        
$result mysql_query"SELECT photo_id,photo_caption,photo_filename FROM gallery_photos WHERE photo_category='".addslashes($cid)."'" );
        
$nr mysql_num_rows$result );

        if( empty( 
$nr ) )
        {
            
$result_final "\t<tr><td>No Category found</td></tr>\n";
        }
        else
        {
            while( 
$row mysql_fetch_array$result ) )
            {
                
$result_array[] = "<a href='viewgallery.php?cid=$cid&pid=".$row[0]."'><img src='".$images_dir."/tb_".$row[2]."' border='0' alt='".$row[1]."' /></a>";
            }
            
mysql_free_result$result );    

            
$result_final "<tr>\n";
    
            foreach(
$result_array as $thumbnail_link)
            {
                if(
$counter == $number_of_thumbs_in_row)
                {    
                    
$counter 1;
                    
$result_final .= "\n</tr>\n<tr>\n";
                }
                else
                
$counter++;

                
$result_final .= "\t<td>".$thumbnail_link."</td>\n";
            }
    
            if(
$counter)
            {
                if(
$number_of_photos_in_row-$counter)
            
$result_final .= "\t<td colspan='".($number_of_photos_in_row-$counter)."'>&nbsp;</td>\n";

                
$result_final .= "</tr>";
            }
        }
    }

    
// Full Size View of Photo
    
else if( $pid )
    {
        
$result mysql_query"SELECT photo_caption,photo_filename FROM gallery_photos WHERE photo_id='".addslashes($pid)."'" );
        list(
$photo_caption$photo_filename) = mysql_fetch_array$result );
        
$nr mysql_num_rows$result );
        
mysql_free_result$result );    

        if( empty( 
$nr ) )
        {
            
$result_final "\t<tr><td>No Photo found</td></tr>\n";
        }
        else
        {
            
$result mysql_query"SELECT category_name FROM gallery_category WHERE category_id='".addslashes($cid)."'" );
            list(
$category_name) = mysql_fetch_array$result );
            
mysql_free_result$result );    

            
$result_final .= "<tr>\n\t<td>
                        <a href='viewgallery.php'>Categories</a> &gt; 
                        <a href='viewgallery.php?cid=
$cid'>$category_name</a></td>\n</tr>\n";

            
$result_final .= "<tr>\n\t<td align='center'>
                    <br />
                    <img src='"
.$images_dir."/".$photo_filename."' border='0' alt='".$photo_caption."' />
                    <br />
                    
$photo_caption
                    </td>
                    </tr>"
;
        }
    }

// Final Output
echo <<<__HTML_END

<html>
<head>
    <title>Gallery View</title>
</head>
<body>
<table width='100%' border='0' align='center' style='width: 100%;'>
$result_final        
</table>
</body>
</html>

__HTML_END;
?>