Problemer med noget egentlig simpel PHP
Jeg har et clanwarscript som jeg har problemer med.Jeg har problemer med kommandoen "SELECT * FROM * WHERE id='".$_get['id']."'" -Nedenunder kommer scriptets 2 filers indhold:
cwar.php:
<?
$db = mysql_connect("localhost", "ascent", "asc");
mysql_select_db("ascent", $db);
?>
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<link rel="stylesheet" type="text/css" href="../css/style.css">
<title>Clanwars</title>
<style type="text/css">
<!--
.style1 {
color: #000000;
font-weight: bold;
}
-->
</style>
</head>
<body style="font-family: Verdana; font-size: 10 px">
<!-- Vis links -->
<table width="540" height="10" border="0" align="center" style="BORDER-COLLAPSE: collapse">
<tr>
<td width="50" height="13">
<span class="style1"></span></td>
<td width="100" height="13"><span class="style1">
<font style="FONT-SIZE: 8pt" face="Verdana">Date</font></span></td>
<td width="150" height="13"><span class="style1">
<font style="FONT-SIZE: 8pt" face="Verdana">Opponent</font></span></td>
<td width="150" height="13"><span class="style1">
<font style="FONT-SIZE: 8pt" face="Verdana">Type</font></span></td>
<td width="90" height="13"><span class="style1">
<font style="FONT-SIZE: 8pt" face="Verdana">Result</font></span></td>
<td width="50" height="13">
<span class="style1"><font style="FONT-SIZE: 8pt" face="Verdana">Details</font></span></td>
</tr>
<?
$foresp = mysql_query("SELECT opponent, game, map1, map2, lineup, dato_dag, dato_mdr, dato_aar, score_us, score_them, rapport, img, land, id FROM clanwars ORDER BY id DESC");
if(!$foresp){
//noget gik galt.
die("Fejl ved SQL udførsel: ".mysql_error());
}
while($data = mysql_fetch_row($foresp)){
echo "<tr><td width='97' height='18' style='font-family: Verdana; font-size: 10 px'><img border='0' src='$data[12]'></td>";
echo "<td width='97' height='18' style='font-family: Verdana; font-size: 10 px'>$data[5]/$data[6]-$data[7]</td>";
echo "<td width='147' height='18' style='font-family: Verdana; font-size: 10 px'>$data[0]</td>";
echo "<td width='147' height='18' style='font-family: Verdana; font-size: 10 px'>$data[1]</td>";
echo "<td width='89' height='18' style='font-family: Verdana; font-size: 10 px'>";
if($data[8] <= $data[9]) {
echo "<font color='#FF0000'>$data[8]-$data[9]</font>";
} else {
echo "<font color='#00CC00'>$data[8]-$data[9]</font>";
}
echo "</td><td width='50' height='18' style='font-family: Verdana; font-size: 10 px'><b><a href='detail_war.php?id=$data[13]'>Here</a></b></td></tr>";
}
?>
</table>
</font>
</body>
</html>
detail_war.php:
<?
$db = mysql_connect("localhost", "ascent", "asc");
mysql_select_db("ascent", $db);
?>
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<link rel="stylesheet" type="text/css" href="../css/style.css">
<title>Clanwars</title>
<style type="text/css">
<!--
.style1 {
color: #000000;
font-weight: bold;
}
-->
</style>
</head>
<body style="font-family: Verdana; font-size: 10 px">
<?
$foresp = mysql_query("SELECT opponent, game, map1, map2, lineup, dato_dag, dato_mdr, dato_aar, score_us, score_them, rapport, img, land, id FROM clanwars WHERE id='".$_get['id']."'");
if(!$foresp){
//noget gik galt.
die("Fejl ved SQL udførsel: ".mysql_error());
}
while($data = mysql_fetch_row($foresp)){
echo "$data[0]<br>$data[1]<br>$data[2]<br>$data[3]<br>$data[4]<br>$data[5]<br>$data[6]<br>$data[7]<br>$data[8]<br>$data[9]<br>$data[10]<br><a target='_blank' href='$data[11]'><img border='0' src='$data[11]' width='120' height='90'></a><br><img src='$data[12]'><br>";
}
?>
</body>
</html>
detail_war.php har jeg ikke gjort så meget ud af, men den skulle gerne kunne hente de forskellige data ned fra det pågældende id, men gør det ikke. Nogen forslag?
