Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › MySQLi Server Behaviors › Query Builder › How acheive random results from a recordset that has INNER JOIN and GROUP BY in its SELECT statement?

View all replies to this thread

How acheive random results from a recordset that has INNER JOIN and GROUP BY in its SELECT statement?

Thread began 10/18/2017 4:58 pm by Nathon Jones Web Design | Last modified 6/13/2018 3:04 pm by Nathon Jones Web Design | 3203 views | 12 replies

10/19/2017 11:09 amRay BorduinWebAssist

Sorry since I bring the table in AS another name you have to update all of the references to it like:

php:

SELECT categories.catID, categories.catTITLE, link.galleryID, galleryRand.domainID, galleryRand.galleryIMG 

FROM categories 

INNER JOIN link ON categories.catID = link.catID 

INNER JOIN (SELECT gallery.* FROM gallery ORDER BY Rand()) AS galleryRand ON link.galleryID = galleryRand.galleryID 

WHERE galleryRand.domainID = 1 GROUP BY categories.catTITLE

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.