sql queries in php
<p>I run a small helpdesk and I have a requirement to produce a ticket report every month to my line manager.</p>

<p>I am looking to upgrade the way in which we produce this report because at present, I run the below query I wrote manually every month by using Navicat:</p>

<pre><code> SELECT
 updates.incidentid AS `Incident ID`,
 updates.bodytext AS `Call Status`,
 updates.duration AS `Total Minutes`,
 software.`name` AS 'Support Type',
 incidents.title AS Description,
 contacts.forenames AS `First Name`,
 contacts.surname AS `Last Name`,
 FROM_UNIXTIME(incidents.opened, '%d.%m.%Y') AS `Date Logged`,
 sites.`name`,
 users.realname
 FROM
 updates
 INNER JOIN incidents ON updates.incidentid = incidents.id
 JOIN contacts ON incidents.contact = contacts.id
 INNER JOIN sites ON sites.id = contacts.siteid
 INNER JOIN users ON incidents.`owner` = users.id
 INNER JOIN software ON incidents.softwareid = software.id
 WHERE
 updates.bodytext = 'Incident Closed'
    AND FROM_UNIXTIME(incidents.opened, '%m') = '07'
            AND FROM_UNIXTIME(incidents.opened, '%Y') = '2016'
 ORDER BY contacts.siteid ASC
</code></pre>

<p>I would like to put this all in a very simple webpage allowing the user select the month and year and then offer them a HTML formatted download.</p>

<p>Would I be best placed to put this in PHP or can I create it in HTML? Please be kind, I am a total newbie and my thought process is a little off.</p>

<p>Many thanks for your time and patience!</p>