Air Compressor Bot
|
|
Home |
How it works |
Projects archive |
Contact Us Air Compressor Bot |
|
| The Career Path of Freelance Programming Jobs |
Php Mysql Queries |
 |
Bidding Time: |
14/04/2008 23:22 - 28/04/2008 23:22 |
Budget: |
N/A |
Status: |
Closed |
|
|
|
Job Type: |
|
Description: |
is a plus. I have a MySQL database with three tables of data. One table is customers, one table is purchases, and one table is sales agents. These tables are already populated with data. I need a web page made with various queries I can run on my database that will display the results of the queries in a table on the page. For example I might want to be able to find customers who have more than 3 purchases, or customers who purchased within the past 2 months, etc. On the web page displaying the results I must be able to sort by each column of data by clicking the column header, and I must be able to customize some of the queries by entering the query criteria. When the results from a query are displayed on the page there needs to be check boxes next to each row and an option to select or deselect all results. I need to be able to do two things to the results with are checked. The first thing is to select some or all of the results with the checkbox and assign a sales agent (from the sales agent table of the satabase) to contact the customers. This should permanently assign a sales agent to those customers. The second thing I need to do is to select some or all of the query results with the checkboxes and generate a comma seperated values (.csv) file for download containing all the data from the selected customers. I need to know which customers have been exported to .csv files and on what date so when this export is done it needs to update a table in the database showing they have been exported. I will supply you with the table structure for my database, but you must build the web page and queries on your own test server. I will not give you access to my cpanel or directly to my database. When the project is complete you will just need to show me where in the code to insert my database name and password etc. and I will implement it on my own server. Related Projects:  Rewriting Project # 3 For Hema Image Management PHP + 350 Words Articles For Infofreek Sinisa2 Mobile Website CloneThis project is the proprietary information of .
Click here to remove this project from OUR database.
|
Operating System: |
N/A |
Database System: |
N/A |
| <<< back |
|
| Home | Projects archive | RSS | Resources | Links | Contact Us | © 2004-2008 ProjectsList.biz /19.695 |