Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › MySQLi Server Behaviors › Query Builder › Filter record base on user and show their status

Filter record base on user and show their status

Thread began 7/15/2021 12:16 am by Rokon | Last modified 7/20/2021 9:48 am by Rokon | 1011 views | 8 replies

7/15/2021 4:57 pmRay BorduinWebAssist

Try:

SELECT users.UserID, users.UserEmail, activity_user.activityID, activity_user.userid, activity_user.itemGroup, activity_user.itemType, activity_user.itemID, hadithmain.HadithID
FROM hadithmain
LEFT OUTER JOIN activity_user ON activity_user.itemID = hadithmain.HadithID AND activity_user.userid = ?
LEFT OUTER JOIN users ON users.UserID = activity_user.userid

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.