Software

Ask something
Question Locked

(php&mysql)

0 helpful
5 replies

by ft85

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

5 replies

by robo_dev

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?

by ft85

(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.

by ft85

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.

This discussion is closed to new replies.