[SOLVED] search db with array

[digitalgod]

hey guys,

 

say I have an array of emails that I'd like to verify if they exist in a db, would there be a better way than having a select query for each email?

 

something other than

 

<?

for ($i=0; $i < $max; $i++)
{
  $query = "SELECT id WHERE email = '" . $aEmail[$i] . "' "
  $result = mysql_query($query) or die(mysql_error());
  $numRows=mysql_num_rows($result);
  
  // etc...
}
?>

[digitalgod]

Don't mind the missing FROM in my $query example. I could have sworn there was a Modify button but all I see is Quote...

[.josh]

$list = implode (',',$aEmail);
$query = "select id from table where id in('$list')";

[sasa]

$list = implode (',',$aEmail);
$query = "select id from table where id in('$list')";

$list = implode ("','",$aEmail);
$query = "select id from table where id in('$list')";

[digitalgod]

thanks Crayon I'll give it a shot.

 

why the "" sasa? I'll try it both ways

[.josh]

Do it sasa's way.

 

I forgot the outer quotes in the implode.  The implode will take your array and make it into a comma and quote separated list, the goal being to make your query string look like this:

 

select id from table where id in ('blah','someotherblah','moreblah')