Help with getting number of rows from database.

[philvia]

I have this in my code.:

$mr = mysql_query("SELECT 

`username`,`userid`,`cookies`,`aura`,`rank` FROM `users` 

WHERE `faction` = ".$faction." ORDER BY `rank` 

DESC,`username` ASC");

echo "<tr><td class=dark align=center>Current 

Factions</tr></td>";

echo "<tr><td class=cell1 align=center>Name</td><td 

class=cell1 align=center>Leader</td><td class=cell1 

align=center>Members</td></tr>";

echo "<tr><td>echo @mysql_num_rows($mr) </td></tr>";

$sql="SELECT * FROM factions ORDER BY factionid";

$result=@mysql_query($sql);

while ($myrow=@mysql_fetch_array($result)) {

echo "<tr><td> ".$myrow["name"]." </td>"; }

?>

I'm trying to get the # of rows from the users table..

All I get is this... : echo @mysql_num_rows($mr)

Any suggestions?

[philvia]

bah, i thought my other post was deleted... it didn't show when i kept refreshing. Sorry about the 2 topics.