[Resolved] Select count into a variable??

[astur]

How can i get the result of a select count query into a variable??

$mysqlquery="Select count(*) from messages where id_msg=5"

I want to get the final result into a variable for instance named $result.

Thank you in advance.

[pete_bisby]

$qry = "SELECT COUNT(*) AS CountRows FROM messages WHERE id_msg=5";
$res = mysql_query($qry, $database);
$row = mysql_fetch_array($res);
$result = $row["CountRows"];

First Line: MySQL query
Second Line: Result of query ($database is the database connection variable)
Third Line: Row from result containing data, as an associative array
Fourth Line: Variable $result set to value

Hope this helps!

[astur]

It worked!!

Thanks a million!!

Now I can continue on the project 😃