Index


There are currently $gesamt Games available in the database.


\n"; echo "\n"; // sort alphabetical if ($display =="alpha") { for ($ludwig=65;$ludwig<=90;$ludwig++) { $gerade=Chr($ludwig); $sql = "SELECT id,title,callname,publisher,identifier FROM ifguide_data WHERE title LIKE \"".$gerade."%\"ORDER BY title"; $result = mysql_query($sql,$conn); echo "$gerade

\n"; while ($ergebnis=mysql_fetch_array($result,MYSQL_ASSOC)) { $p=$ergebnis["title"]; $p=substr($p,0,(strlen($p)-1)); $q=$ergebnis["id"]; $r=$ergebnis["identifier"]; $r=ereg_replace(" ","%",$r); $s="-1,".$q; echo "$p \n"; $p=$ergebnis["callname"]; echo "$p, \n"; $p=$ergebnis["publisher"]; echo "$p
\n"; } echo "

\n"; } } // sort by manufacturer if ($display =="manufacturer") { $sql = "SELECT identifier FROM ifguide_data"; $sresult = mysql_query($sql,$conn); while ($sergebnis=mysql_fetch_array($sresult,MYSQL_ASSOC)) { $gerade=$sergebnis["identifier"]; if ($gerade1 <> $gerade) { $sql = "SELECT id,title,callname,publisher,identifier FROM ifguide_data WHERE identifier='$gerade' ORDER BY title"; $result = mysql_query($sql,$conn); echo "$gerade

\n"; while ($ergebnis=mysql_fetch_array($result,MYSQL_ASSOC)) { $p=$ergebnis["title"]; $p=substr($p,0,(strlen($p)-1)); $q=$ergebnis["id"]; $r=$ergebnis["identifier"]; $r=ereg_replace(" ","%",$r); $s=$r.",".$q; echo "$p \n"; $p=$ergebnis["callname"]; echo "$p, \n"; $p=$ergebnis["publisher"]; echo "$p
\n"; } echo "


\n"; } $gerade1=$gerade; } } ?>


Go back to the Table of Contents