can I select the SUM of columns and...

[Anon]

Hi There,

Can I select the SUM of columns in my database as well as select the number of rows in the database (ie. mysql_num_rows)?

This is my sql statement:

$sql = "SELECT SUM(cash) AS cash_total,SUM(visa) AS visa_total,SUM(mastercard) AS mc_total,SUM(amex) AS amex_total,SUM(gst) AS gst_total,SUM(pst) AS pst_total,SUM(items) AS items_total FROM sales";

What would I need to add to it to get the number of rows?

Thanks,

-dr

[bdbush]

select count(*) from table

Should give you the number of rows. Although, I would use the mysql_num_rows function.

Don't be too quick to try to solve all of your problems in the SQL statement. Sometimes it is easier and faster to do in code.

--brian