Jump to content

Looping through a mySQL IN() query.. and stuck


monkeytooth

Recommended Posts

Ok, this is my query..

 

SELECT email FROM memb_loginInfo WHERE email IN ('".$email."') ORDER BY email ASC

 

Which if I run that through phpMyAdmin I yield 5 results, even running it through my script I am still yielding 5 results as per echoing out the num_rows tells me. But when I try to loop through the output arrays worth of data I can only get the first result. I have tried for, foreach, while to no success. Only thing that outputs anything is the foreach. Yet I only get one.

 

						foreach($row as $found)
					{
						//echo $found;
						$outputArray['output'][] = array('name' => "none", 'email' => $row['email']);
					}			

 

Where am I going wrong here?

You're not showing enough of your code, but it would go something like this:

 

$query = "SELECT email
          FROM memb_loginInfo
          WHERE email IN ('{$email}')
          ORDER BY email ASC";
$result = mysql_query($query);

while($row = mysql_fetch_assoc($result))
{
    echo "{$row['email']}<br>\n";
}

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.