[SOLVED] while() & MySql problem

[Michdd]

I'm using this:

 

$result = mysql_query("SELECT * FROM middlemen ORDER BY name") 
or die(mysql_error());

while($row = mysql_fetch_array( $result )) {

$name = $row['name'];
$status = $row['status'];

while($status = "Middle Man") {

echo "<li>".$name."</li>";

}

}

 

Now, to test it I put 1 user in the database with the status: Middle Man. And it just repeated the name over and over. How would I make it so that it only each name, once?

[.josh]

while($status == "Middle Man") {

 

= is assignment

== is comparison

[Michdd]

while($status == "Middle Man") {

 

= is assignment

== is comparison

Wow, that was the stupidest mistake I ever made.. Thanks.