help with something like match.php?id=1

[sno]

im trying to get this page to show the users information relevent the user user id which is added on at the end.
the only thing i get is no mysql errors but just blank fields.

this is what i have.

[code]

<?
$query = "SELECT * FROM $global[pre]_results WHERE match_id='$id'";

$result = mysql_query ($query) or die (mysql_error());

while ($s = mysql_fetch_array($result)) {

$id=$s["match_id"];
$against=$s["against"];
$map=$s["map"];
$results1=$s["results1"];
$results2=$s["results2"];
$info=$s["info"];
}

echo("The stuff from mysql should show up here
[/code]

is there a obvious reason as to why it isnt working??

[cmgmyr]

try global $id; at the top.

[onlyican]

$global[pre]_results???

Thats the table name, stick it in a var
If your trying to get to global version for it
global $pre

and use $_GET["id"];
to get the ID from the address bar

[craygo]

put this on top

$id = $_GET['id'];

Ray

[wildteen88]

I'd suggest you use this instead:
[code]// if you are expecting id to be a number. Check that its a number before using it!
if(isset($_GET['id']) && is_numeric($_GET['id']))
{
    $id = $_GET['id'];
}
// id is not a number or is not set so we kill the script.
else
{
    die('Invalid URL Parameter');
}[/code]
Add that before
[code]$query = "SELECT * FROM $global[pre]_results WHERE match_id='$id'";[/code]

[sno]

wildteen88, i tryied yours out and even when i put a number in it gives the invalud URL parameter part...
i got the [code]$id = $_GET['id'];[/code]in for now

[onlyican]

if ur using $_GET
the format is string, not int
even if the string contains 56
It is a string
"56" is different to 56

[wildteen88]

@onlyican - That shouldnt matter with is_numeric. As it compares whether a variable is either a number or a number string.

@sno - change my code snippet provided above to this:
[code=php:0]if(isset($_GET['id']) && is_numeric($_GET['id']))
{
    $id = $_GET['id'];
}
// id is not a number or is not set so we kill the script.
else
{
    echo 'DEBUG INFO:<br />
<br />
id - ' . $_GET['id'] . '<br />
id is: ' . gettype($_GET['id']) . '<br /><br />';
}[/code]

What do you get now?