sql script for reports

See more:

SQL

PHP

MySQL

hi there


Please i need help , am having a database where i connect and run a report daily .

now i would like to work on a sort of web link for these report i run daily , so that i give a link to the users to access the report;

below is the script that i use for a specific report.

SELECT DATE(date), COUNT(*) AS Total, -SUM(amount) AS Collected FROM dailytask
Where  group = 'serves'
AND amount < 0 AND DATE(date) >= 'yyyy-mm-dd'
group by DATE(date)

can anybody help me code this , as am trying to connect to the Database and fetch the result from the db and display it to the web.


Thanks a million in advance for your help .