lijstje

[mats]

http://www.mattie.be/cheats.php ,
als je op een leter drukt komt er een fout ,
weten jullie soms welke?
en hoe ik die moet oplosen
alvast bedankt

<hr />fixed

<hr />[syntax="PHP"]
&lt;?php

if($_GET["id"] != NULL){
$dbh=mysql_connect("***", "***", "****") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("****", $dbh);
$sql = "SELECT * FROM cheats WHERE id='".$_GET["id"]."'";
$resultaat = mysql_query($sql) or die(mysql_error());
$aantal = mysql_num_rows($resultaat);
if($aantal == 0){echo"Dit id bestaat niet!";}
while ($record = mysql_fetch_object($resultaat)) {
echo"&lt;table border=\"0\"&gt;";
echo"&lt;tr&gt;";
echo"&lt;td&gt;Spel: &lt;b&gt;".$record-&gt;naam."&lt;/b&gt;&lt;/font&gt;&lt;/td&gt;";
echo"&lt;/tr&gt;";
echo"&lt;tr&gt;";
echo"&lt;td&gt;Datum: &lt;b&gt;".$record-&gt;datum."&lt;/b&gt;&lt;/font&gt;&lt;/td&gt;";
echo"&lt;td&gt;&lt;a href='?pag=cheats/cheats&amp;letter=".$_GET["letter"]."'&gt;&lt;i&gt;Terug&lt;/i&gt;&lt;/a&gt;&lt;/font&gt;&lt;/td&gt;";
echo"&lt;/tr&gt;";
echo"&lt;/table&gt;";
echo"&lt;br&gt;";
echo $record-&gt;text;
}
}
elseif($_GET["letter"] != NULL){
$dbh=mysql_connect("**", "**", "**") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("***", $dbh);
$sql = "SELECT * FROM cheats WHERE letter='".$_GET["letter"]."'";
$resultaat = mysql_query($sql) or die(mysql_error());
$aantal = mysql_num_rows($resultaat);
echo"Er zijn $aantal cheats gevonden met de letter ".$_GET["letter"];
echo"&lt;table border=0&gt;&lt;tr&gt;&lt;td&gt;&lt;b&gt;Spel&lt;/b&gt;&lt;/td&gt;&lt;td&gt;&lt;b&gt;Datum&lt;/b&gt;&lt;/td&gt;&lt;/tr&gt;&lt;br&gt;";
while ($record = mysql_fetch_object($resultaat)) {
echo"&lt;center&gt;&lt;tr&gt;&lt;td&gt;&lt;a href='?pag=cheats/cheats&amp;letter=".$GET["letter"]."&amp;id=".$record-&gt;id."'&gt;".$record-&gt;naam."&lt;/a&gt;&lt;/td&gt;&lt;td&gt;".$record-&gt;datum."&lt;/td&gt;&lt;/tr&gt;&lt;/center&gt;";
}
echo"&lt;/table&gt;";
}else{
$letters = array("0-9","a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z");
$i=1;
echo"&lt;a href='?pag=cheats/cheats&amp;&amp;letter=".$letters[0]."'&gt;".$letters[0]."&lt;/a&gt;";
while($i != count($letters)){
echo" |&lt;a href='?pag=cheats/cheats&amp;letter=".$letters[$i]."'&gt;".$letters[$i]."&lt;/a&gt;";
$i++;
}
}

?&gt;
[/syntax]

Hoe kan ik ervoor zorgen dat de scripts gewoon allemaal onderelkaar staan (zonder ergens op te klikken) en dat die letters wegzijn???
alvast bedankt

<hr />wete nieamnd oplossing??

[Derk]