php mysql row, else?

[dezkit]

how do i do so if theres nothing in that table, i can echo "There isn't anything, yet."

 

while($row = mysql_fetch_array($result)){
  echo $row["member"];
  echo "<br>";
}

 

 

 

i was thinking

while($row = mysql_fetch_array($result)){
  echo $row["member"];
  echo "<br>";
} else {
echo "there are any members yet";
}

but it doesnt work.

[poleposters]

$query="SELECT * FROM table WHERE this=this";

$result=mysql_query($query);

$number=mysql_num_rows($result);

 

if($number>0)

 

{

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

  echo $row["member"];

  echo "<br>";

}

else

{

echo " NO users have joined";

}

[Orio]

<?php

if(mysql_num_rows($result) == 0)
  echo "nada";
else
{
   while()....
}

?>

 

Orio.