Re: [PHP-DB] php mysql arrays and totals

2003-07-18 Thread Dirk Kredler
Am Freitag, 18. Juli 2003 12:33 schrieb Wendell Frohwein: > 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, SUM() is a standard function from (my)SQL. just use it and be happy, if you need in depth deta

Re: [PHP-DB] php mysql arrays and totals

2003-07-18 Thread Wendell Frohwein
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" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Am Freitag, 18. Juli 2003 12:18 schrieb Wendell Frohwein: > > called

Re: [PHP-DB] php mysql arrays and totals

2003-07-18 Thread Dirk Kredler
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) FR

[PHP-DB] php mysql arrays and totals

2003-07-18 Thread Wendell Frohwein
I have been searching all over the internet and yet I have not found the answer to my problem. I have a mysql database which stores dollar amounts. The table is called items, the field is called amount. I use mysql_query("SELECT amount FROM items"); to get the amounts into the script. I would then