values of mysql query into an array...

[mkosmosports]

Hey everyone,

What I want to do is retrieve one column from a mysql table, insert it into an array, and then put a condition saying that if the url parameter containing that column value is not in the array, to go to an error page.

What I have now is:

$team=$_GET["team"];

$getallteam = @mysql_query("SELECT ID FROM sf_team");

if (!$getallteam)
{
    echo("<p>Error performing query: " . mysql_error() . "</p>");
exit();
}

while($row = mysql_fetch_array($getallteam))
{
$teamid = $row["ID"];

After that, Im not sure what to do. Can anyone help me?

Thanks.

[JasonLewis]

try this:

[code=php:0]
  $team=$_GET["team"];

  $getallteam = @mysql_query("SELECT ID FROM sf_team");

  if (!$getallteam)
  {
      echo("<p>Error performing query: " . mysql_error() . "</p>");
      exit();
  }

  while($row = mysql_fetch_array($getallteam)){
  $teamid[] = $row['ID'];
}

if(!in_array($team, $teamid)){
echo "ID is not in array!";
}else{
echo "ID is in array!";
}
[/code]

but if your just using it to check if an ID exists there are easier ways...