MySQL output to php echo

Question

I made this MySQL query to sum a column then i did echo $rake and i got the output : Resource id #13

It will be highly appreciated if anyone can assist me with this

<?php 
        $rake = mysql_query("select sum(value) as RakeSum from rakeitems");

        echo $rake;

?>

Did i forget something after the query? I am not very good at mysql so im unsure. Any help will be nice :) I have tried changing the query up.

And what does as do in the query, "as RakeSum" what does that mean?

as RakeSum means that when you go to see the data, it's column name will be RakeSum. otherwise the name would be sum(value) as the column. You can run this in the mysql database to see (with and without as) — A. L
– A. L, Commented Dec 11, 2016 at 8:36
Ok thanks could yo fix the resource id #13 output im getting? — Strykes
– Strykes, Commented Dec 11, 2016 at 8:39
It's a resource, meaning you need to run it through mysql_fetch_assoc see: stackoverflow.com/questions/7785401/… — A. L
– A. L, Commented Dec 11, 2016 at 8:40
It sounds like you are just learning php/mysql, then dont' waste time on mysql_* dangerous and removed in php 7. Learn PDO — e4c5
– e4c5, Commented Dec 11, 2016 at 9:00

Sifat Haque · Accepted Answer · 2016-12-11 08:58:44Z

0

Here $rake is a resource
give a look here to know how to use mysql_fetch_assoc to get data from a resource

answered Dec 11, 2016 at 8:58

Sifat Haque

6,1272 gold badges18 silver badges24 bronze badges

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

1 Answer 1