Question

Locked

(php&mysql)

By ft85 ·
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

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

To clarify a bit

by robo_dev In reply to (php&mysql)

Do you have a web server?

What sort of web server?

The word "mysql" appears in the header. Is that the database you use? Is the database installed on the web server, or separately, on a different server?

Collapse -

Reponse To Answer

by ft85 In reply to To clarify a bit

(php&mysql)
am using Apache Webserver on linux , and mysql as a database running on that same Server.

Thanks

let me know if u have any other questions for clarification.

Collapse -

(php&mysql)

by ft85 In reply to (php&mysql)

am using Apache Webserver on linux , and mysql as a database running on that same Server.

Thanks

let me know if u have any other questions for clarification.

Collapse -

t

by ft85 In reply to (php&mysql)
Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums