:: Meuser :: Music Search Type your query below The results must contain: > all typed words > any typed words Bitrate equal to Anyone >64 >128 >192 Kbit >Search also in the albums 1){ for ($i=0;$i<$cq;$i++){ if ($i<($cq-1)){ if($all) $mais = " AND "; else $mais = " OR "; } else{ unset($mais); } if($albums) $albums = " OR album LIKE'%".$query[$i]."%'"; $AdvancedQuery = $AdvancedQuery."(mp3 LIKE '%".$query[$i]."%'$Bitrate)$albums$mais"; } } else if ($cq==1){ if($albums) $albums = " OR album LIKE'%".$query[0]."%'"; $AdvancedQuery = "(mp3 LIKE'%".$query[0]."%'$Bitrate)$albums"; } if($type=='' || $type==0){ $type = 1; $ORDER = "growing"; } else{ $type = 0; $ORDER = "decreasing"; } if($order){ if(type==1){ $type_order = "ASC"; } else if($type==0){ $type_order = "DESC"; } $orderBy = "$order $type_order"; } else{ $orderBy = "mp3 ASC"; } $var = Select($tbl_musicas,"(".$AdvancedQuery.") ORDER BY $orderBy"); $c = count($var); print "Your search ($queryA) returned $c occurrence(s) - Listing in $ORDER order "; if($c) echo ""; for ($i=0;$i<$c;$i++){ if(!$C){ $cor = '#F3F3F3'; $C = true; } else{ $cor = '#DDDDDD'; $C = false; } print ""; } if($c) echo " Title Length Size Album #CD Bitrate Layer ".eregi_replace(".mp3","",$var[$i][7])." ".$var[$i][5]." ".$var[$i][2]." ".$var[$i][6]." ".$var[$i][8]." ".$var[$i][4]." ".$var[$i][3]." "; } else{ unset($buscar); } } ?>

Search engine powered by eDev