i didnt even know that function existed, could you maybe give me a little more detail on it, then im sure i can figure it out, thanks allot, -wendell "Dirk Kredler" <dirk@computication.net> wrote in message 200307181226.11385.dirk@computication.net">news:200307181226.11385.dirk@computication.net... > Am Freitag, 18. Juli 2003 12:18 schrieb Wendell Frohwein: > > called amount. I use mysql_query("SELECT amount FROM items"); to get the > > amounts into the script. > > I would then like all the values to be added up for a grand total. I have > > tried this and the > > why dont you use : > > SELECT SUM(amount) FROM items > > ? > > best wishes, > Dirk > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php