if(!isset($_GET[lett])) { $let = "(LEFT(title,1) REGEXP '[0-Z]')"; }
if($_GET[lett] == "a") { $let = "(LEFT(title,1) REGEXP '[a]')"; }
if($_GET[lett] == "b") { $let = "(LEFT(title,1) REGEXP '[b]')"; }
if($_GET[lett] == "c") { $let = "(LEFT(title,1) REGEXP '[c]')"; }
if($_GET[lett] == "d") { $let = "(LEFT(title,1) REGEXP '[d]')"; }
if($_GET[lett] == "e") { $let = "(LEFT(title,1) REGEXP '[e]')"; }
if($_GET[lett] == "f") { $let = "(LEFT(title,1) REGEXP '[f]')"; }
if($_GET[lett] == "g") { $let = "(LEFT(title,1) REGEXP '[g]')"; }
if($_GET[lett] == "h") { $let = "(LEFT(title,1) REGEXP '[h]')"; }
if($_GET[lett] == "i") { $let = "(LEFT(title,1) REGEXP '[i]')"; }
if($_GET[lett] == "j") { $let = "(LEFT(title,1) REGEXP '[j]')"; }
if($_GET[lett] == "k") { $let = "(LEFT(title,1) REGEXP '[k]')"; }
if($_GET[lett] == "l") { $let = "(LEFT(title,1) REGEXP '[l]')"; }
if($_GET[lett] == "m") { $let = "(LEFT(title,1) REGEXP '[m]')"; }
if($_GET[lett] == "n") { $let = "(LEFT(title,1) REGEXP '[n]')"; }
if($_GET[lett] == "o") { $let = "(LEFT(title,1) REGEXP '[o]')"; }
if($_GET[lett] == "p") { $let = "(LEFT(title,1) REGEXP '[p]')"; }
if($_GET[lett] == "q") { $let = "(LEFT(title,1) REGEXP '[q]')"; }
if($_GET[lett] == "r") { $let = "(LEFT(title,1) REGEXP '[r]')"; }
if($_GET[lett] == "s") { $let = "(LEFT(title,1) REGEXP '[s]')"; }
if($_GET[lett] == "t") { $let = "(LEFT(title,1) REGEXP '[t]')"; }
if($_GET[lett] == "u") { $let = "(LEFT(title,1) REGEXP '[u]')"; }
if($_GET[lett] == "v") { $let = "(LEFT(title,1) REGEXP '[v]')"; }
if($_GET[lett] == "w") { $let = "(LEFT(title,1) REGEXP '[w]')"; }
if($_GET[lett] == "x") { $let = "(LEFT(title,1) REGEXP '[x]')"; }
if($_GET[lett] == "y") { $let = "(LEFT(title,1) REGEXP '[y]')"; }
if($_GET[lett] == "z") { $let = "(LEFT(title,1) REGEXP '[z]')"; }
$anime_list = "SELECT *
FROM `ac_anime`
ORDER BY title ASC";
?>
|
|
function add_stars($rating) {
switch ($rating)
{
case 10: $stars = "http://www.animecrave.com/_content/images/STARS/5Stars.png"; break;
case 9: $stars = "http://www.animecrave.com/_content/images/STARS/4_5Stars.png"; break;
case 8: $stars = "http://www.animecrave.com/_content/images/STARS/4Stars.png"; break;
case 7: $stars = "http://www.animecrave.com/_content/images/STARS/3_5Stars.png"; break;
case 6: $stars = "http://www.animecrave.com/_content/images/STARS/3Stars.png"; break;
case 5: $stars = "http://www.animecrave.com/_content/images/STARS/2_5Stars.png"; break;
case 4: $stars = "http://www.animecrave.com/_content/images/STARS/2Stars.png"; break;
case 3: $stars = "http://www.animecrave.com/_content/images/STARS/1_5Stars.png"; break;
case 2: $stars = "http://www.animecrave.com/_content/images/STARS/1Stars.png"; break;
case 1: $stars = "http://www.animecrave.com/_content/images/STARS/_55tars.png"; break;
case 0: $stars = "http://www.animecrave.com/_content/images/STARS/0Stars.png"; break;
} return $stars;}
$result_list = $Db->query($anime_list);
while ($data = mysql_fetch_array($result_list)) {
echo "
\n";
}
?> |
|
|