Write a mySQL query
$10-30 USD
Paid on delivery
Hi - I need an optimized, fast query that lets me display collections of images - three per collection (See attached image that shows one collection. In reality I'd be displaying bunches of these sets of three, each its own collection.)
There are three tables: collections, which has a title and unique ID for each collection; collection_items, which holds the image IDs along with a collection ID (the "parent" collection); and finally a files table, which contains the image ID that matches the one in collection_items. I can send a DB dump if you're interested in the project. Hopefully this should be a piece of cake for a mySQL pro. Thank you!
Project ID: #18601955
About the project
8 freelancers are bidding on average $23 for this job
I am experienced php developer and web designer with the depth knowledge related to MySQL,Laravel,WordPress,MSSQL,JSON,JAVASCRIPT,AJAX,XML,jQuery,CSS,HTML5,Material Designing with the integration of web technologies. I More
Hello Sir, Please send me the dump of db. One more thing right now you are showing the images in a set of 3 as per collection id, so whats the difference you are looking in terms of output or you just want to imp More
hi, I've read your project requirement about mysql query and I can do it successfully because it suits by skill set. Thanks Zee.
We have proficient knowledge of SQL and we can complete this work in 1 hour. Please let us know if you are good to go with us.