MySQL Query using php explode arrary as WHERE

Question

After several hours of tinkering I cannot seem to figure this out. I have a table in the database which holds a CSV field full of values. After using the php explode function I am left with an array.

$emailarray = list($email) = explode(",", $csv);


while($arrayreadable = mysql_fetch_array($emailarray,$emailcount[0])){



$makefeed = mysql_query("SELECT email,name FROM $statusdatabase WHERE email = $arrayreadable[`0`]'");
while ($friendfeedget = mysql_fetch_assoc($makefeed)) {

[Code for what I want the loop to do]

}


}

Sarfraz · Accepted Answer · 2010-12-27 09:19:07Z

2

Instead of looping through and issuing mysql query each time, you can use the IN clause in your query like this:

$emailarray = list($email) = explode(",", $csv);
$emails = implode(',', $emailarray);

$makefeed = mysql_query("SELECT email,name FROM $statusdatabase WHERE email IN ('".$emails."')");

while ($friendfeedget = mysql_fetch_assoc($makefeed)) {
  // code
}

answered Dec 27, 2010 at 9:19

Sarfraz

384k81 gold badges561 silver badges613 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

kwallbmoc Over a year ago

For some reason I am unable to get your solution to work. The query works without error but the where seems to not find any matches.

Sarfraz Over a year ago

You should specify list of email separated by comma in where clause.

Collectives™ on Stack Overflow

MySQL Query using php explode arrary as WHERE

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related