lets say this is an example. Lets say I have table A with 100 random numbers between 0 and 9
I will provide how many items I want, lets say 10 (this number I need to be able to change). I need then to read last 10 entries in that table A and find out number of occurrences of each of those digits.
then based on the number of occupancies I like to display the highest choices based on the following criteria:
1. If we have two digits tied for the top pick, use only those digits, plus the second best digit (with ties) in our combinations.
2. If there are three or more digits tied for the highest frequency, use only those digits for that position.
3. If we have two or more digits tied for the second highest frequency in a position, use the highest and the second highest digit with ties.
4. If we have any ties with the third highest frequency digit use only the top and second picks.
I did play with mysql while back and I know a lot of those frequencies can be handled inside mysql, I prefer to use mysql for it rather than getting items from DB to php and then processing it as speed might be a factor. I think mysql can handle large quantities of numbers much better than php would. But I need php so I can integrate it into my website.","employmentType":["FULL_TIME","PART_TIME","CONTRACTOR","TEMPORARY","PER_DIEM"],"jobLocationType":"TELECOMMUTE","hiringOrganization":{"@type":"Organization","name":"Toogit","sameAs":"https://www.toogit.com/","logo":"https://www.toogit.com/images/toogit_logo_initial.png"},"identifier":{"@type":"PropertyValue","name":"Toogit","value":305765},"skills":["MySQL Administration","MySQL Programming"],"applicantLocationRequirements":[{"@type":"Country","name":"IN"},{"@type":"Country","name":"Canada"},{"@type":"Country","name":"USA"},{"@type":"Country","name":"Germany"},{"@type":"Country","name":"Pakistan"},{"@type":"Country","name":"Philippines"},{"@type":"Country","name":"Indonesia"},{"@type":"Country","name":"Sri Lanka"},{"@type":"Country","name":"Nigeria"},{"@type":"Country","name":"China"},{"@type":"Country","name":"Russia"},{"@type":"Country","name":"Bangladesh"}],"validThrough":"2024-07-05T18:24:45+05:30","url":"https://www.toogit.com/freelance-jobs/MzA1NzY1"}
Remote Web Development Job In IT And Programming
Find more Web Development remote jobs posted recently Worldwide
Work from Anywhere
40 hrs / weekFixed Type
Remote Job$23.98
Cost Looking for help? Checkout our video tutorial
How to search and apply for jobs
How to apply? Do you have more questions about the Job?
See frequently asked questions
We are looking for an experienced WordPress developer to customise the WPML (wordpress multi language) plugin. He or she needs to be proficient in PHP and JavaScript and experienced with WordPress and the WPML plugin. The current WordPress site is qu...read more
We have hosted a Bare Metal Server in vultr.com, this is a unmanged server having whm/cpanel. configuration is - cpu 8 core, ram 32 gb. we have hosted a mobile app on this server, the app is based on Online Live Training, completely live streaming ba...read more
I have multiple sites on Godaddy that are often hacked. They are ALL WP sites. Simple on-going work (when the hacks appear) to safe guard and ensure that they are not hacked. They are ALL sub domains under a single primary domain. First step is to do...read more
Hi -
This is an RFP for a wider piece of work around reformatting some and excel database into MySQL and building BI capability, using Tableau, PowerBI, or Python.
For the RFP we have a test set to answer several questions, the tes...read more