Re: problem with a while loop

your while loop is working fine -- it's just that you're re-setting the value of $email every time it loops through. I'm not sure what you're trying to accomplish, but you might try something like: $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"] } //untested code -- probably missing some quotes somewhere. that will give you an array with lname as the key and e_mail_1 as your value. You can then loop through it and format it however you want. hth --kurt On Friday 26 October 2001 00:10, Richard Kurth wrote: > 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;