[SOLVED] Whats wrong with this line of php

[skippa]

$c=mysql_query(" 'SELECT * FROM `users` WHERE status='Alive' ORDER BY `users`.`health` ASC LIMIT 0, 10 ';");

  while($d=mysql_fetch_object($c)){

  echo "<tr><td><a href='profile.php?viewuser=$d->username'>$d->username</a></td><td>$d->health</td><td>$d->rank</td></tr>";

 

[stockton]

Which line? If your query is the SQL line I would write it as follows.

$c=mysql_query("SELECT * FROM `users` WHERE status='Alive' ORDER BY `users`.`health` ASC LIMIT 0, 10;");