Confused on how to create this loop...

[sgtpepper]

Hi! What I want to accomplish....should be simple...but I am not sure how to do it.

In my table I have several rows of names.....I want to be able to somehow have the below sql query....automatically loop all of the names in the database. Basically, I want this query to run for each of the names in the database.

Any ideas on how I can set this up?

$query1="SELECT * FROM contact where name='new_name_here'";

[YappyDog]

You should be able to use a while loop to go through all your data. Something like:

$query1="SELECT * FROM contact where name = 'new_name_here'";
$rs=mysql_query($query1, $conn);
while($row=mysql_fetch_array($rs)){
echo $row["name"] . "<br>";
}