help with passing variables in url

[btd117]

I am tring to create a link like this:

/page.php?id=2

I have this code:

<?php

include 'admin/global.php';


$result = mysql_query("SELECT * FROM ncaa ORDER BY id WHERE id='$id'");

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

  print '<p>' .$row['id']. '</p>';
 
}

?>

the page yields no results...what am I missing? The id field is set as the primary in the dB. Any help would be greatly appreciated.

[trq]

[code=php:0]
$result = mysql_query("SELECT * FROM ncaa ORDER BY id WHERE id='{$_GET['id']}'");
[/code]