get value "select count(*) from tbl where i='

[Anon]

hi.
I am using the Oracle8.1.6 as the Database for PHP.

How to get the values of this SQL :
"select count(*) from table_name where sort='xxxx'" ?????

thinks.

[Anon]

perhaps it'll be easier if you change your SQL statement like this :
$qry = "select count(*) AS arbitrary_field_name from table_name where sort='xxxx'"

then to fetch it you may use :
$result = mysql_query($qry);
list($rs) = mysql_query($result);

OR

$rs = mysql_fetch_array($result);
echo ($rs["arbitrary_field_name"]);

Hope it works