Mysql row data return

Question

I want to count the value of column in MySQL and show the result in my page using PHP.

I tried this to get the column value

$smt=$conn->prepare("SELECT SUM(Admin_Status) FROM aplic");
$smt->execute();
$result=$smt->fetch(PDO::FETCH_OBJ);
$res=$result->SUM(Admin_Status);
echo $res;

To be more specific, I'm making a PM (personal messaging system) and for that I created the read and unread column in the table, now I want that user see how many new messages (s)he has.

Give your sum an alias -> "SELECT SUM(Admin_Status) as AdminStatusSum FROM aplic" which you can then access -> $result->AdminStatusSum; — Sean
– Sean, Commented Aug 8, 2014 at 5:20

Aeolun · Accepted Answer · 2014-08-08 05:31:27Z

1

You cannot use the return value of the query that way because PHP will interpret it as a method to execute.

If you give the field you retrieve an alias in the query, you'll be able to use it correctly from the object.

SELECT SUM(Admin_Status) AS status FROM aplic

Will allow you to use

$result=$smt->fetch(PDO::FETCH_OBJ);
$res=$result->status;
echo $res;

Alternatively, you might be able to use the following syntax

$res=$result->{'SUM(Admin_Status)'}

But I'd very much vote on using the first alternative and just giving the returned column an alias.

edited Aug 8, 2014 at 5:31

answered Aug 8, 2014 at 5:23

Aeolun

7568 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mysql row data return

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related