count

[Deccypher]

hi i got the count functon working but this it the first time i have ever used it
[php]$_result = mysql_query(" SELECT COUNT( * ) FROM `table` WHERE `colum` = '$sid' ");
echo "$_result Phones Supported"; [/php]
i can tell my echo is wriong. but i dont know what i should be doing here

Please enclose your posted code in [code] tags (See How to Ask a Question). Please use [code] tags in future.

MODERATOR

[DavidPr]

You may try something like this:

[PHP]$query = "SELECT COUNT(*) AS numrows FROM `table` WHERE colum = '$sid'";
$result = mysql_query($qu ery);
$row = mysql_fetch_arr ay($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
}
echo "$numrows Phones Supported";[/PHP]

or

[PHP]$query = "SELECT COUNT(*) FROM `table` WHERE colum = '$sid'";
$result = mysql_query($qu ery);
while($row = mysql_fetch_arr ay($result))
{
$number = $row['COUNT(*)'];
}
echo "$number Phones Supported"; [/PHP]

[Deccypher]

Works great,

thank you i just couldn't figure out how to show the results when the query itsself was the result and not generating variables.

this is going in my bookmarks lol

thanks again

[Markus]

Or, if i understand your problem, you could use the mysql_num_rows( )'s function.

[php]
$_query = mysql_query(".. .");
$_rows = mysql_num_rows( $_query);
echo $_rows;
[/php]

[Deccypher]

Or, if i understand your problem, you could use the mysql_num_rows( )'s function.

[php]
$_query = mysql_query(".. .");
$_rows = mysql_num_rows( $_query);
echo $_rows;
[/php]

this bit will solve the overall problem thanks

[Markus]

this bit will solve the overall problem thanks

Welcome!

See you around.

Markus.