Đang Thực Hiện

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! ***

Kỹ năng: Bất kì công việc gì, MySQL, PHP

Xem thêm: webmasters for hire, top 10 programmers, sorting of data, sorting logic, php mysql programmers for hire, mysql php programmers, mysql db, it and programmers hire, hire logic, mysql top 10, top programmers, mysql copy, it programmers for hire, hire programmers, hire programmer to modify script, g1, float, f2, f1, send email php mysql, mysql sort field, mysql sort, sort criteria, reveal button, display mysql

Về Bên Thuê:
( 17 nhận xét ) Petaling Jaya, Malaysia

Mã Dự Án: #1759439

Đã trao cho:

photoshop

Ready to start :)

$44 USD trong 1 ngày
(195 Đánh Giá)
7.6