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
