zocke.es Suchergebnisse für
prepare("SELECT g.id, g.title, g.description, g.plays, g.thumbnail, c.name FROM `games` g LEFT JOIN `categories` c on c.id=g.category WHERE g.title LIKE :search OR g.description LIKE :search ORDER BY (CASE WHEN g.title LIKE :search THEN 1 ELSE 0 END) DESC LIMIT 30"); if ($statement->execute(array(':search' => "%" . $q . "%"))) { $AnzGames = $statement->rowCount(); while ($games = $statement->fetch()) { $num = 0; $gezeigteGames = 0; $gameurl = cleanGameURL($games['title']); $games['description'] = stripslashes($games['description']); if (strlen($games['description']) > 145) { $games['description'] = substr($games['description'], 0, 145) . "..."; } else { $games['description'] = $games['description']; } $num++; $gezeigteGames++; if (substr($games['thumbnail'], 0, 4) != "http") {$games['thumbnail'] = $siteurl . $games['thumbnail'];} echo '
'; $row['title'] = str_replace("&", "&", $row['title']); if ($seo == 'yes') { echo '' . $games['title'] . '' . cleanGameCatName($games['title']) . '

' . $num . '

' . $games['description'] . '

'; } elseif ($seo == 'no') { echo '' . cleanGameCatName($games['title']) . '

' . $games['description'] . '

'; } if ($gezeigteGames == $AnzGames && $num != 2) {echo '

';} if ($num == 2) { echo '
'; $num = 0;} if ($gezeigteGames != $AnzGames && $num != 2) {echo "
";} } } else { $AnzGames = 0; echo "SQL Error
"; echo $statement->queryString . "
"; echo $statement->errorInfo()[2]; } } if ($AnzGames == 0) { echo "

Leider habe ich zu deinem Suchwort/deiner Suchphrase ($q) nichts gefunden!

"; $zwischenDIV = ''; //echo "
 
"; }else{ $zwischenDIV = '

'; } echo '
' . $zwischenDIV . '
'; /*echo '


';*/ include 'rightcolumn.php'; include 'footer.php';?>