Databridge V2 with MySQLi support IS Now Available!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › selecting content

View all replies to this thread

selecting content

Thread began 6/12/2020 3:24 am by Jamie | Last modified 6/12/2020 11:50 am by Jamie | 36 views | 2 replies

6/12/2020 9:32 amRay BorduinWebAssist

SELECT service_contents.*, join_expertise.*, staff.* FROM service_contents INNER JOIN join_expertise ON service_contents.ServicesID = join_expertise.RowsExpertiseContentID INNER JOIN staff ON join_expertise.RowsStaffContentID = staff.StaffID WHERE service_contents.ServicesID = ? GROUP BY StaffID ORDER BY IF(Locate('Head of Family Children',StaffJob)<>0,1,0), StaffOrder ASC

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.