SUM results from columns in mysql table

ivane

Hi can someone help me on this issue

I have mysql table:

CREATE TABLE desktop (
  id int(11) NOT NULL auto_increment,
  click int(11) NOT NULL default '0',
  url varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

and I wish to accomplish to have mysql result shown

$sql=(select SUM(click) from desktop);

echo "$sql";

It is not working .. can somebody help me to resolve this problem.
I have allready opened db connection.

What I wish is to SUM results from rows in colum click and echo them but I cannot work it out.

Thanks

sid

ok...

$sql=(select SUM(click) from desktop); 

echo "$sql";

doesntr really do much but assigning a string (which happens to look like a query) to a variable which happens to be called $sql

try

$query = "select SUM(click) from desktop";
$result = mysql_query($query);
$row = mysql_fetch_array($result);

echo "$row[0]";

this isnt very clean and also not the best version =- but it should do the job - im not that familiar with the mysql funcs - so im sure someone will post a better version...

hope it helps anyway...

Mega

$query = "select SUM(click) from desktop";
$result = mysql_query($query);
$row = mysql_fetch_array($result);

echo "$row[0]";

$query = 'select SUM(click) from desktop';
$result = mysql_query($query);
$row = mysql_fetch_array($result);

echo $row[0];

less parsing, more speed 🙂 start as u mean to go on

sid

do the quotation marks make such a big difference?