Software

Question

Gravatar
0 Votes
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.

Thread display: Collapse - | Expand +

All Answers

gravatar
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?

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

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

gravatar
Collapse -

t

by ft85 In reply to (php&mysql)
Back to Software Forum

Start or search

Related Discussions

Related Forums