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":270131},"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-26T21:36:36+05:30","url":"https://www.toogit.com/freelance-jobs/MjcwMTMx"}
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.89
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
I have one AWS WHM server. Need to Fix this.
[x] setup amazon ec2, s3, rds, cloudfront on AWS
- [ ] 1. LAMP installation on centos
- [ ] 2. WHM installation
- [ ] 3. CDN setup for one domain with S3
Work should be done remotely
Hello World,
Important - please read carefully this proposal(!)
We are looking for professional individual PHP backend developer with specific experience with WordPress templates and WordPress plugins development.
General...read more
We are looking for a Database Administrator Summary: The Database Administrator is responsible for protecting enterprise data. Day to day functions include the management, installation, deployment, monitoring and ongoing support of enterprise databas...read more
We are looking for an experienced Sr. Data Architect to help us
create a next-generation automation platform. You will be responsible for:
- Creating and optimizing information schemas to support business objectives
- Designing and p...read more