Question
Thread display: Collapse - |
All Answers
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
(php&mysql)
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