select specific id's (this must be real easy)

[EfEnrico]

here is the deal I want to select specific id's from a database table..

how?

<?
 include($_SERVER["DOCUMENT_ROOT"]."/mundus/include/dbconnect.php");
$id = ("7" "9");
$query = "SELECT * FROM links WHERE id = '$id'";
 $resultaat = mysql_query($query);
 
 # display results
 while ($data = mysql_fetch_object($resultaat)) {
 $sitename = "$data->sitename"; 
$siteurl = "$data->siteurl";
  echo ("<A HREF='$siteurl' target='_blank'>$sitename</A><br>\n");
  }
?>

above doesnt work though...

[carneddau]

I think you're after something like this:

$id = "(7, 9)";
$query = "SELECT * FROM links WHERE id IN '$id'";