Count(*)

[ca_vishnukumar]

Hi
I 've a query
$sql="select count() from table";
How to get the result [count()] in PHP ?
Vishnu

[jcleary]

The way I do it is

$sql="select count(*) as reccount from table";

then you can

echo $row["reccount"];

or whatever

[Anon]

Vishnu
I think u can do it link this . You might have to modify something here.

$query = "select count(*) from table";
$reault = MYSQL_QUERY($query)

while($arr = mysql_fetch_array($result))
{
echo $arr[fieldname]
}