How can i read the amount result of a specific column within a line/row? Mysql + php

Question

How can i count all numbers in 'status' within the lines of 'user_registration'?

this is what i have. it works good, but it just shows the amount of lines within 'user_registration'.

 <?php
    $con = mysql_connect($dbHost, $dbUser, $dbPass );
    mysql_select_db($dbName, $con);
    $res = mysql_query('SELECT Count(*) FROM ' . 'user_registration', $con);
    if ($row = mysql_fetch_array($res, MYSQL_NUM))
    {
       $users = trim($row[0]);
    }
    else
    {
       $users = 'Error';
    }
    ?>

to Show result on website:

<?= $users ?>

Answer 1

If I understand your question correctly:

SELECT SUM(status) FROM user_registration

Here more info on MySQL aggregate functions: http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html

---

P. S. As Jay suggested in comments, consider moving away from mysql_* functions.