Write a database frontend

You will write a front end that queries my database of domain names. The database is a MySQL database running on a Linux server and consists of 18 million records (some are only partially populated). The database will be accessible by a fronted web page written by you or using a CMS. There are 10 fields in the DB - the ones important for you are:- - Index - Domain - The name and the extension - .[login to view URL] or .uk - Registered - Whether registered or not - Suspended - Whether the suspended or not - Created - Domain creation date - Expiry - Domain expiration date I wish the database queries to:- - Find domains that, minus the extension (e.g. .[login to view URL] or .uk) have a registered flag for the .[login to view URL] varient but not the .uk and vica versa. - Be able to display all domains with an expiry date that is X number or more (days) of the current date. I will specify X. - Be able to display all domain with a creation date that X number or less (days) of the current date. I will specify X. - Display all domains with a suspended status (suspended is a field in the DB) - Display all domains that, minus the extension (e.g. .[login to view URL] or .uk) have a suspended flag for the .[login to view URL] variant but not the .uk and vica versa reg - List all domains that are of a certain length. I will specify the length and the count of the length should not include the domain's extension. The code should not be compromisable by SQL injection. All fields that are displayed will be sortable. I wish to be able to click on the displayed column to see the sort and then click on a second column to apply a secondary sort to the result. There will be an option to display between 50, 100 and 500 records per page.