Re: How do you sum columns.

SELECT SUM(fieldName) FROM tablename [insert where clauses]; --Joe On Thu, Oct 19, 2000 at 04:26:32PM +0000, Christopher King wrote: > I have a PHP MYSQL form that returns rows from a query on the date. > > I have a field that holds the item's weight. After the user chooses to > display a series of products by date I want to display a total weight of > those items in a separate table below the returned rows. > > How do you sum columns. > > Thanks > > > -- > Christopher King > chris@create4u.com > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net /*****************************\ * Joe Stump * * www.Care2.com * * Office: 650.328.0198 * * Extension: 122 * \*****************************/ http://www.miester.org/Joe/Stump/Joe_Stump_resume.html -----BEGIN GEEK CODE BLOCK----- Version: 3.12 GB/E/IT d- s++:++ a? C++++ UL++$ P+ L+++$ E----! W+++$ N+@ o? K? w---! O-@ M+@ V-! P(++) PE(+) Y+@ PGP+++@ t+@ 5? R-! tv@ b+ DI++@ D(++++) G++@ e+@ h@ r+! z(+++++**)! ------END GEEK CODE BLOCK------