MySQL and PHP developer.

MySQL and PHP developer. We are a growing company and we need somebody that can work 20hrs per week writing scrips and other things for our CMS. Hello,

Here is a further description of what we need done. Right now, this is building reports using scripts to pull the info from our CMS written in PHP.

For reporting:

The builder would need a solid understanding of mySQL and PHP. The reports are simply SELECTs and JOINs of various tables within one database. Custom scripts are needed to pull together particular data from different tables and display them with a number of options (offered in the PHP-coded pages). As well, if the builder could construct faster queries or furnish ideas on how to accelerate or optimize the current queries, that would an extra help. Finally, the builder should be able to setup code to export the results in a Excel or CSV format.

Below are two simple SELECT queries, which demonstrate a simple example of what they do:

SELECT category, categoryID as newID,
(SELECT COUNT(issueID) FROM hrh_issues WHERE hrh_issues.categoryID = newID) as numberIssues,
(SELECT COUNT(issueID) FROM hrh_issues WHERE hrh_issues.issue_date > DATE_ADD(CURDATE() , INTERVAL -12 MONTH) AND hrh_issues.categoryID = newID) as last12months,
(SELECT COUNT(issueID) FROM hrh_issues WHERE hrh_issues.issue_date > DATE_ADD(CURDATE() , INTERVAL -90 DAY) AND hrh_issues.categoryID = newID) as last90days
FROM hrh_categories

(Second example)

SELECT count(issueID), Client_Name, MONTH(issue_date) as theMonth, YEAR(issue_date) as theYear
FROM hrh_issues, clients
WHERE clients.clientID = hrh_issues.clientID
AND clients.Broker = 6222
AND issue_date > DATE_ADD(CURDATE() , INTERVAL -13 MONTH)
GROUP BY YEAR(issue_date), MONTH(issue_date) , hrh_issues.clientID