March 27th, 2002, 11:53 AM
|
|
Contributing User
|
|
Join Date: Apr 2007
Location: Florida
Posts: 4,158
Time spent in forums: 4 h 12 m 16 sec
Reputation Power: 7
|
|
|
RE: column sum
you could use something like the following:
$db = mysql_connect("localhost","user","pass")
or die("Problem connecting");
mysql_select_db("dbname")
or die("Problem selecting database");
$query = "SELECT SUM(column) as total FROM table";
$result = mysql_query($query)
or die ("Query failed");
$row = $mysql_fetch_array($result);
echo $row['total'];
Hope that helps....
|
Codewalkers Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
