\n";
$select = "SELECT * FROM cheats WHERE ";
if ($search_platform) {
$select.= "console = '".$search_platform."' AND (";
$select.= "'".$search_query."' IN (title) OR MATCH (title,cheats) AGAINST ('".$search_query."'))";
} else {
$select.= "'".$search_query."' IN (title) OR MATCH (title,cheats) AGAINST ('".$search_query."')";
}
$select.= " order by title";
$query = mysql_query($select,$db);
$tot = mysql_num_rows($query) or die(mysql_error());
$start = (($no*$DisplayNo)-$DisplayNo);
echo "Displaying results ".(1+$start)." - ".min($tot,$no*$DisplayNo)." of ".$tot." cheats \n";
$pages = ceil($tot/$DisplayNo);
if ($pages<=1) {
echo "
\n";
} else {
paginateSearch($no,$pages,$search_query,$search_platform);
}
$query = mysql_query($select." limit $start,$DisplayNo",$db);
$result = mysql_fetch_array($query) or die(mysql_error());
do {
$start++;
echo $start.". ".$result['title']." ";
echo "(".$result['console'].") \n";
} while ($result = mysql_fetch_array($query));
if ($pages<=1) {
echo "
";
?>Did you find this cheat useful?
\n";
} else if ($platform!="") {
echo "
".$pageTitle."
\n";
$query = mysql_query("SELECT * FROM cheats where console = '$platform'",$db);
$tot = mysql_num_rows($query) or die(mysql_error());
$pages = ceil($tot/$DisplayNo);
$start = (($no*$DisplayNo)-$DisplayNo);
echo "Displaying ".(1+$start)." - ".min($tot,$no*$DisplayNo)." of ".$tot." cheats\n";
paginatePlatform($no,$pages,$esc_platform);
$query = mysql_query("SELECT * from cheats where console = '$platform' order by title limit $start,$DisplayNo",$db);
$result = mysql_fetch_array($query) or die(mysql_error());
do {
$start++;
echo $start.". ".$result['title']." \n";
} while ($result = mysql_fetch_array($query));
paginatePlatform($no,$pages,$esc_platform);
} else if ($letter!="") {
$page = "letters";
echo "
".$pageTitle."
";
$query = mysql_query("SELECT * FROM cheats where letter = '$letter'",$db);
$tot = mysql_num_rows($query) or die(mysql_error());
$pages = ceil($tot/$DisplayNo);
$start = (($no*$DisplayNo)-$DisplayNo);
echo "Displaying ".(1+$start)." - ".min($tot,$no*$DisplayNo)." of ".$tot." cheats\n";
paginateLetter($no,$pages,$letter);
$query = mysql_query("SELECT * from cheats where letter = '$letter' order by title limit $start,$DisplayNo",$db);
$result = mysql_fetch_array($query) or die(mysql_error());
do {
$start++;
echo $start.". ".$result['title']." ";
echo "(".$result['console'].") \n";
} while ($result = mysql_fetch_array($query));
paginateLetter($no,$pages,$letter);
} else {
echo "
".$BlurbTitle."
\n";
echo $BlurbText." \n \n";
?>
\n";
echo "
\n
Most Popular Cheats
\n
";
$select = "SELECT * FROM cheats order by hits DESC limit 0,10";
$query = mysql_query($select,$db);
$result = mysql_fetch_array($query) or die(mysql_error());
do {
echo "
";
} while ($result = mysql_fetch_array($query));
echo "
";
?>
\n";
echo "
\n
Top Rated Cheats
\n
";
$select = "SELECT * FROM cheats order by rating DESC limit 0,10";
$query = mysql_query($select,$db);
$result = mysql_fetch_array($query) or die(mysql_error());
do {
echo "
