I am trying to get the data out of the while loop if I echo $email inside the } it gives me all of the data but if I echo it out side of the loop it only gives me one record even though I know there is more. How can I get this to work
$query = "SELECT * FROM members Where Company LIKE '%$search1%'"; $result=mysql_db_query($dbName,$query); while ($row = mysql_fetch_array($result)) { $email= $row["lname"] . " " . "<" . $row["E_mail_1"] . ">" . ";"; } echo $email; -- Best regards, Richard mailto:[EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]