Basic SQL/PHP DIsplay and Administrative Interface

Sample SQL attached. View Component: Display all servers that is not status 0 Show the following columns in display: name, dyndns, status, down, service_tag, serial_number, contact_name, street_address, city, state, zip, phone, email, computer_type, computer_ram account_number from server_info All the way on the right, you should be able to press an "Edit" button At the very bottom of the page, it should say: Number of servers: X (total # of servers that are not status 0) Number of servers by an array of computer_type and computer_ram Administrative Component for New Server We need to be able to create new servers. When we create a new server, we will need to enter the following information: Server Name: name Dyndns: dyndns Service Tag: service_tag Serial Number: serial_number Contact Name: contact_name Street Address: street_address City: city State: state Zip Code: zip Phone Number: phone Email Address: email Computer Type: computer_type Computer RAM: computer_ram Account Number: (allowed to be blank) Internet Type: type Bandwidth: bandwidth_out [SUBMIT] When you submit a new server, you should create a new entries in "server" and "server_info": Server Server Name -> name Updated -> updated (in 2009-11-11 07:25:00 format, EST) Dyndns -> dyndns Location -> NULL Status -> 1 Down -> 0 Powerx10id -> NULL Service Tag -> service_tag Serial Number -> serial_number Contact Name -> contact_name Street Address -> street_address City -> city State -> state Zip Code -> zip Phone Number -> phone Email Address -> email Server_info Server Name: -> server_name Internet Type: -> type Disabled -> 1 Instances -> 4 Ultra_connections -> 125 Network_interface -> eth0 X10id -> NULL Dslhop -> 0 Bandwidth -> bandwidth_out Address -> NULL Account Number -> account_number Updated -> updated (in 2009-11-11 07:25:00 format, EST) [Same as above] Administrative Component for Edit Server When you edit a server, all of the items should be editable on the Edit Page. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables): a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform SQL/PHP