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"]
<?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"<table border=\"0\">";
echo"<tr>";
echo"<td>Spel: <b>".$record->naam."</b></font></td>";
echo"</tr>";
echo"<tr>";
echo"<td>Datum: <b>".$record->datum."</b></font></td>";
echo"<td><a href='?pag=cheats/cheats&letter=".$_GET["letter"]."'><i>Terug</i></a></font></td>";
echo"</tr>";
echo"</table>";
echo"<br>";
echo $record->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"<table border=0><tr><td><b>Spel</b></td><td><b>Datum</b></td></tr><br>";
while ($record = mysql_fetch_object($resultaat)) {
echo"<center><tr><td><a href='?pag=cheats/cheats&letter=".$GET["letter"]."&id=".$record->id."'>".$record->naam."</a></td><td>".$record->datum."</td></tr></center>";
}
echo"</table>";
}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"<a href='?pag=cheats/cheats&&letter=".$letters[0]."'>".$letters[0]."</a>";
while($i != count($letters)){
echo" |<a href='?pag=cheats/cheats&letter=".$letters[$i]."'>".$letters[$i]."</a>";
$i++;
}
}
?>
[/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??