Related questions about Mysql:select count (*) from XXX

Questions about Mysql:select Count (*) from XXX
There's nothing wrong with this statement in the MySQL console.
return result 0

But in PHP $result=select count (*) from XXX
What do I do with the returned results?
The $result I got is not what I expected. 0

For example, I want the Select COUNT (*) from XXX to not find the data and then execute the Insert data

How can i solve it?

Just contact Php+mysql not long ago, used. Net+mssql used to, MySQL's statements are many different

------Solution--------------------
$data = $db->query ($sql);
List ($total) = $data->fetchrow ($data);

$total is the result you want.

