Databridge V2 with MySQLi support IS Now Available!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › I want to only 1 record per user, DISTINCT or UNIQUE or something like that

I want to only 1 record per user, DISTINCT or UNIQUE or something like that

Thread began 2/10/2022 11:35 am by jo271221 | Last modified 2/15/2022 11:31 am by Ray Borduin | 104 views | 1 replies |

2/10/2022 11:35 am | #1 jo271221

I want to only 1 record per user, DISTINCT or UNIQUE or something like that

SELECT p.*,d.logo_img,d.businessname,d.firstname,d.lastname, d.membership_type FROM tbl_posts p INNER JOIN tbl_directorylistings d ON(d.id = p.customerid) WHERE p.displaylevel = 'Public' AND p.customerid !='' AND d.membership_type = 'PV' ORDER BY p.dateposted DESC

I want to show only 1 post per id ie customerid

2/15/2022 11:31 am | #2 Ray BorduinWebAssist

You can probably use GROUP BY to show only 1 like:

SELECT p.*,d.logo_img,d.businessname,d.firstname,d.lastname, d.membership_type FROM tbl_posts p INNER JOIN tbl_directorylistings d ON(d.id = p.customerid) WHERE p.displaylevel = 'Public' AND p.customerid !='' AND d.membership_type = 'PV' GROUP BY customerid ORDER BY p.dateposted DESC

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.