Hello, this is how I'm searching a database now...is there an easier way
(PHP)? Anything that's short would be nice. This is just really long.
$searchgenre = "punk, hardcore, classical, acoustic";
$formatted_query = str_replace(", ", ",", $searchgenre);
$genre_array = split(",", $formatted_query);
$result = count($genre_array);
if ($result == "1") {
$sql_text = "SELECT * FROM artists WHERE genre like '%$genre_array[0]%'
ORDER BY artist ASC";
}
if ($result == "2") {
$sql_text = "SELECT * FROM artists WHERE genre like '%$genre_array[0]%' OR
genre like '%$genre_array[1]%' ORDER BY artist ASC";
}
if ($result == "3") {
$sql_text = "SELECT * FROM artists WHERE genre like '%$genre_array[0]%' OR
genre like '%$genre_array[1]%' OR genre like '%$genre_array[2]%' ORDER BY
artist ASC";
}
if ($result == "4") {
$sql_text = "SELECT * FROM artists WHERE genre like '%$genre_array[0]%' OR
genre like '%$genre_array[1]%' OR genre like '%$genre_array[2]%' OR genre
like '%$genre_array[3]%' ORDER BY artist ASC";
}
if ($result == "5") {
$sql_text = "SELECT * FROM artists WHERE genre LIKE '%$genre_array[0]%' OR
genre LIKE '%$genre_array[1]%' OR genre LIKE '%$genre_array[2]%' OR genre
LIKE '%$genre_array[3]%' OR genre LIKE '%$genre_array[4]%' ORDER BY artist
ASC";
}
if ($result == "6") {
$sql_text = "SELECT * FROM artists WHERE genre LIKE '%$genre_array[0]%' OR
genre LIKE '%$genre_array[1]%' OR genre LIKE '%$genre_array[2]%' OR genre
LIKE '%$genre_array[3]%' OR genre LIKE '%$genre_array[4]%' OR genre LIKE
'%$genre_array[5]%' ORDER BY artist ASC";
}
if ($result == "7") {
$sql_text = "SELECT * FROM artists WHERE genre LIKE '%$genre_array[0]%' OR
genre LIKE '%$genre_array[1]%' OR genre LIKE '%$genre_array[2]%' OR genre
LIKE '%$genre_array[3]%' OR genre LIKE '%$genre_array[4]%' OR genre LIKE
'%$genre_array[5]%' OR genre LIKE '%$genre_array[6]%' ORDER BY artist ASC";
}
if ($result == "8") {
$sql_text = "SELECT * FROM artists WHERE genre LIKE '%$genre_array[0]%' OR
genre LIKE '%$genre_array[1]%' OR genre LIKE '%$genre_array[2]%' OR genre
LIKE '%$genre_array[3]%' OR genre LIKE '%$genre_array[4]%' OR genre LIKE
'%$genre_array[5]%' OR genre LIKE '%$genre_array[6]%' OR genre LIKE
'%$genre_array[7]%' ORDER BY artist ASC";
}
if ($result == "9") {
$sql_text = "SELECT * FROM artists WHERE genre LIKE '%$genre_array[0]%' OR
genre LIKE '%$genre_array[1]%' OR genre LIKE '%$genre_array[2]%' OR genre
LIKE '%$genre_array[3]%' OR genre LIKE '%$genre_array[4]%' OR genre LIKE
'%$genre_array[5]%' OR genre LIKE '%$genre_array[6]%' OR genre LIKE
'%$genre_array[7]%' OR genre LIKE '%$genre_array[8]%' ORDER BY artist ASC";}
if ($result == "10") {
$sql_text = "SELECT * FROM artists WHERE genre LIKE '%$genre_array[0]%' OR
genre LIKE '%$genre_array[1]%' OR genre LIKE '%$genre_array[2]%' OR genre
LIKE '%$genre_array[3]%' OR genre LIKE '%$genre_array[4]%' OR genre LIKE
'%$genre_array[5]%' OR genre LIKE '%$genre_array[6]%' OR genre LIKE
'%$genre_array[7]%' OR genre LIKE '%$genre_array[8]%' OR genre LIKE
'%$genre_array[9]%' ORDER BY artist ASC";
}
if ($result > "10") {
print "<font face=Arial size=2>Sorry, you've entered too many genres to
search for, please enter 10 or fewer.</font><br>";
}
Thanks everybody,
Tyler Longren
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
