function SearchCD( $Code = '' , $Title = '' , $Category = '' , $Subcategory = '' , $Publisher = '' , $Year = '' ) { $Query = ''; if ( $Code != '' ) $Query .= " AND `cd_code` = '$Code'"; if ( $Title != '' ) $Query .= " AND `cd_title` LIKE '%$Title%'"; if ( $Category != '' ) $Query .= " AND `cd_category` LIKE '%$Category%'"; if ( $Subcategory != '' ) $Query .= " AND `cd_subcategory` LIKE '%$Subcategory%'"; if ( $Publisher != '' ) $Query .= " AND `cd_publisher` LIKE '%$Publisher%'"; if ( $Year != '' ) $Query .= " AND `cd_year` = '$Year'"; if ( $Query != '' ) { $Query = substr( $Query , 4 ); $Query = 'SELECT * FROM `cd` WHERE' . $Query . ';'; } else $Query = 'SELECT * FROM `cd`;'; $CD_List = array(); $Sqlr = mysql_query( $Query ); while ( $CD_Details = mysql_fetch_array( $Sqlr ) ) $CD_List[] = new CD( $CD_Details ); return $CD_List; }