Käynnissä

8572 mysql db sorting

Summary: -------- A simple script to data (comma delimited text in text file) into mysql database and sort the results according the criterias I specify (details below). Results (in plain text, in comma separated data) will be emailed to the $email variable defined in the [url removed, login to view] file. ======= DETAILS ======= There will be 2 tables: ----------------------- Fields in the table 1: ----------------------- F1 (integer) F2 (float) F3 (integer) F4 (integer) F5 (integer) F6 (text) Ascending/Descending Sort ------------------------- If I click on the "F3" field title, it will sort 'ascending'. (smallest value at the top) If I click on the "F3" field AGAIN, it will sort 'descending'. (biggest value at the top) Field F4 and F5 can be sorted in the same way as well. Criteria Sort ------------- 1) Specify Minimum value for F3 - display results has the min. value OR MORE in the F3 field. E.g. I specify "20" as the min. value, then it will display all records that has F3 = 20 or more 2) Specify Minimum value for F4 - display results has the min. value OR MORE in the F4 field. E.g. I specify "10" as the min. value, then it will display all records that has F4 = 10 or more 3) Specify MAXIMUM value for F5 - display results has the max. value OR SMALLER in the F5 field. E.g. I specify "50" as the max value, then it will display all records that has F5 = 50 or SMALLER *NOTE: Flexibility to select results must match: - Criteria 1 OR 2 OR 3 - Criteria 1 OR 2 AND 3 - Criteria 1 AND 2 AND 3 *** Note: if this sounds confusing, don't worry - sample text/data file will be provided to the chosen programmer. It will be very clear once you see the sample data. Email Results ------------- A button to click "Send email" the results to the email specified in the [url removed, login to view] file. Results should be in plain text. Email subject is entered in the '[url removed, login to view]' file as well. ---------------------- Fields in the table 2: ---------------------- G1 (integer) G2 (integer) G3 (integer) G4 (text) *note: basically this is the same as "table 1" above - same program and sorting logic. The only difference is that the number of fields (only 4 fields). You just need to copy the script for table 1, modify it a little and it will work for table 2. NOTE: ===== This is "work-for-hire" - i.e. I will own the source code and you may NOT resell the code to other webmasters or reveal the program logic. Looking for long term relationship with a few good programmers who are willing to do 'work-for-hire'. *** Happy Bidding! ***

Taidot: kaikki käy, MySQL, PHP

Näytä lisää: webmasters hire, sorting logic, php mysql programmers hire, mysql php programmers, mysql db, hire logic, mysql top, top programmers, mysql copy, hire programmer modify script, g1, float, f2, f1, send email php mysql, mysql sort field, mysql sort, sort criteria, display mysql, sorting data, mysql copy database, variable mysql, mysql source, match records, click reveal script

About the Employer:
( 17 reviews ) Petaling Jaya, Malaysia

Projektin tunnus: #1759439

Myönnetty käyttäjälle:

photoshop

Ready to start :)

44 $ USD 1 päivässä
(195 arvostelua)
7.6