need help with finding number of rows in a field.

[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 get the name to show but when i try and get the # of users in the faction (row users) all I get is echo @mysql_num_rows() .

Any suggestions?

[jeremuck]

Your syntax is incorrect.

I don't think you get string interpolation with functions...

//you can have 
echo "some text " . myfunction() . "some more text";

//or  (I actually wish this was not a feature)
echo "this is some text $text";

//I always use this except in HERE docs
// just so there's no confusion
echo "this is some text " . $text . "<br>";

// but you cannot have: no no no
echo "this is some text: myfunction()";

[philvia]

doesn't get it

[jeremuck]

PHP supports expanding (or interpolating) variables inside string literals but not functions.
Any value that's not a function or a variable is known as a literal... it's something that you the programmer gives to the program
like this:

// this is a literal:
"in between the double quotes"
//or numbers
342

Normally, you use an expression to assign these literals to variables. That way, whenever you call the variable name, you get that value back.
like this:

//assign string to variable
$mytext = "hello world";

In above example, hello world is the literal, and mytext is the name of the variable, signfified by the $ sign.
PHP has a feature that inside double quotes, it automagically "expands" or "interpolates" variable names inside string literals.
this lets you do this:

//outputs: mytext: hello world
$mystring = "hello world";
echo "mytext: $mystring";

This is in contrast to other programming languages where you MUST concatenate different types to eachother. In other words, the literal and the variable are considered so different, you must tell the program when you are using one, rather than the other. For instance, in C++:

cout <<< "this is some text: " <<< myvarname <<< endl;

In PHP, the similar way of doing things is:

//outputs: mytest: hellow world
$mystring= "hello world";
echo "mytext is: " . $mystring;

The dot operator (the period ".") concatenates each value to the last one.
It doesn't rely on string interpolation.
Now, when it comes to functions, you are asking PHP to go execute a different bunch of code. So you can't just interpolate functions into strings. You cannot do this:

echo "mytext is myfunction()";
// This outputs: mytext is myfunction()

Instead, you must do this:

function myfunction()
{
  // returns the literal (not variable) "hello world"
  return "hello world";
}
echo "mytext is " . myfunction() . "more text";

Change you code to reflect the above principle. Look at the part where it is printing the name of the function instead of actually calling it.
Here's the string documentation:
http://us2.php.net/manual/en/language.types.string.php