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
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
Am Dienstag, 22. Juli 2003 11:29 schrieb Ron Allen:
> This is what I have
> select * from ticket where Type = 'Line' and Closeddate = ' empty space'
> and have tried the following
> select * from ticket where Type = 'Line' and Closeddate = 'Null'
> select * from ticket where Type = 'Line' and Close
