Simple php mysql search page

Create a php script for a simple search of the mysql table. Table script is given here. CREATE TABLE `build_data` ( `id` int(11) NOT NULL auto_increment, `hpn` int(11) default NULL, `description` varchar(255) default NULL, `vendor_code` varchar(20) default NULL, `brand` varchar(10) default NULL, `model` varchar(10) default NULL, `qty` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; This should be a keyword search of the following fields: hpn, description, model, vendor_code Results should display all data in the matching records. Sort should be selectable: model, vendor code, description. Default sort is "model.". I will handle the application of style sheets. You will need to test this on your server, as I cannot provide access to our server. Regarding the connection from php to mysql, please leave the values blank and I will modify the script to communicate with our mysql db.