计算MySQL中的特定行

Question

If I want to count one specific row (unread) in my database, how should i proceed with this MySQL query? As of now it counts the whole table.

$result_notifications = mysql_query("select count(1) FROM bhost_notifications where taker_id='$user_info[u_id]'");
$row_notifications = mysql_fetch_array($result_notifications);
$total_notifications = $row_notifications[0];

Answer 1

You need to alias the column.

SELECT COUNT(1) AS count ...

Then you would call $row_followers[count]. Be aware that mysql_ functions are deprecated. Learn about prepared statements when passing variables, and use PDO or MySQLi - this article will help you decide which.