$aCategory = substr($package_album_category,0,4); $bCategory = substr($package_album_category,0,8); $cCategory = substr($package_album_category,0,12); $Search =" AND view_state='Y' "; $Search.=" AND self_estimate_view='Y' "; if(substr($bCategory,4,4)=="0000") { $Search.=" AND SUBSTRING(package_album_category,1,4)='".$aCategory."' "; }else if(substr($cCategory,8,4)=="0000") { $Search.=" AND SUBSTRING(package_album_category,1,8)='".$bCategory."' "; }else{ //$Search.=" AND SUBSTRING(package_album_category,1,12)='".$cCategory."' "; } $sql = mysql_query("SELECT * FROM packageAlbum WHERE 1 ".$Search." ORDER BY listorder ASC, uid DESC",$dbconn); $num = mysql_num_rows($sql); if($num) { echo "
"; } ?>