how to echo

[ctcp]

<?php
$sum_num = mysql_query("SELECT SUM(likes) as totallikes FROM facebook");
echo $sum_num;	

?>

 

i got this result Resource id #27

how to get a number only?

 

[phporcaffeine]

$sum_num becomes a resource, that you can then use against something like mysql_fetch_array(), to return an actual array (list,stack ... etc) of results.

[Psycho]

When you run a query the system provides a resource ID to the results of that query. You need to use one of the mysql_fetch functions or mysql_result() to extract the data from the result set.

 

//Create teh query
$query = "SELECT SUM(likes) as totallikes FROM facebook";
//Run the query (and get a resource identifier)
$result = mysql_query($query);
//Extract the result from the resource
$sum_num = mysql_result($result, 0);
echo $sum_num;   

 

Note: typically you will want to use one of the mysql_fetch variants to cycle through the records returned in a result set. But, for a single value query mysql_result() works well.

[phporcaffeine]

<?php
$sum_num = mysql_query("SELECT SUM(likes) as totallikes FROM facebook");
$rows = mysql_fetch_array($sum_num);
print_r($rows);
?>

[ctcp]

When you run a query the system provides a resource ID to the results of that query. You need to use one of the mysql_fetch functions or mysql_result() to extract the data from the result set.

 

//Create teh query
$query = "SELECT SUM(likes) as totallikes FROM facebook";
//Run the query (and get a resource identifier)
$result = mysql_query($query);
//Extract the result from the resource
$sum_num = mysql_result($result, 0);
echo $sum_num;   

 

Note: typically you will want to use one of the mysql_fetch variants to cycle through the records returned in a result set. But, for a single value query mysql_result() works well.

thanks