Resource id #5

[Coruba67]

OK... weird thing going on here (at least I think it is)

I am trying to get the sum of all the values in a column.

my query goes as follows

$query= "select sum(qty) from table";
$total = mysql_query($query);

then later on I

echo "$total";

all good!

Then when I go to view the results in tha page the only thing that is printed where the result is meant to be is:

Resource id #5

Does anyone know whats going on here?

thanks in advance!! 🙂

[eoghain]

Well if you read the manual for [man]mysql_query/man you will see that it returns a resource, not the result of your query directly. If you want to see what your query returns you need more code:

$query= "select sum(qty) AS qty from table";  // added AS to make things easier later on
$total = mysql_query($query);

$row1 = mysql_fetch_row($total);
echo $row1["qty"];