Mine

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 );                if ( $Sqlr === false ) {                        echo "MySQL Error: ";                        die( mysql_error() );                }                echo "Number of results: " . mysql_num_rows( $Sqlr );                while ( $CD_Details = mysql_fetch_array( $Sqlr ) )		        $CD_List[] = new CD( $CD_Details );                }                return $CD_List;}