Variable in URL is not being recognized by code???

1337phpn00b

Hey, check out this page (the one in question):
http://stcharlessoccer.com/index.php?page=longgame&id=6

The id of the game post is supposed to be 6 but the script insists on showing id number 5 no matter what I set the id to in the URL. Here is the code for the whole page...

<link rel="stylesheet" type="text/css" href="style.css">
<title>Game Article</title>

<?php 

$connection = mysql_connect("localhost" , "stchsccr_root" , "tekken");
$db = mysql_select_db("stchsccr_stcharles");

$q = mysql_query("SELECT * from games where id = '$_GET[id]'"); 
$result = mysql_query($q) or die
("Could not execute query : $q." . mysql_error());

while ($row=mysql_fetch_array($result))
{
$id=$row["id"];
$date=$row["date"];
$scsteam=$row["scsteam"];
$oppteam=$row["oppteam"];
$scscore=$row["scscore"];
$oppscore=$row["oppscore"];
$longd=$row["longd"];
?>

<center><h3><? echo"$scsteam"; echo"<br>"; echo"vs."; echo"<br>";  echo "$oppteam"; ?></h3><br>
<? echo "$longd"; ?>
<hr width=80 color=black>


<div align=center> 

<?php
}
?>

</div>

Thanks

LordShryku

I've always had trouble with using a system variable in a string. Try removing the variable from the string.

$q = mysql_query("SELECT * from games where id = '".$_GET['id']."'");

1337phpn00b

I get this error:

Could not execute query : Resource id #11.You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Resource id #11' at line 1

LordShryku

because you are querying twice. Remove one of the mysql_query's

$q = mysql_query("SELECT * from games where id = '$_GET[id]'");

$result = mysql_query($q) or die
("Could not execute query : $q." . mysql_error());

1337phpn00b

When I do that, no text at all shows up on the page...

1337phpn00b

Oh, never mind! I figured it out. I just had to change one little thing. Thanks for all your help everyone!