array in a query

[ollmorris]

I have an array and I want it to be able to be queried with all the items, and not just one. here is my array and what I want my query to be:

$array = (1, 2, 3);

$QUERY = mysql_query("SELECT * FROM table WHERE name=$array");

Merry Xmas

[cgraz]

<?

// Connect To MySQL Server

@mysql_connect($server, $username, $password) or die("Couldn't Connect to Database");

// Select Database

@mysql_select_db($database) or die("Couldn't Select Database");

// don't forget to use array() when defining an array
// the way you had it would produce a parse error
$array = array(1, 2, 3);

$query = "SELECT * FROM your_table";

echo $query . "<br>\n";

for ($i=0; $i < count($array); $i++) {

  if ($query == 'SELECT * FROM your_table') {
     $query .= " WHERE name='$array[$i]'";
  } else {
     $query .= "  OR name='$array[$i]'";
  }

}

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

// do whatever you want with the results

?>

Don't forget to change your_table to your table name in the select statement AND in the if statement.

Cgraz