Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › Self Join - To use a repeat region in recordset

Self Join - To use a repeat region in recordset

Thread began 12/27/2020 5:58 am by msbannister373603 | Last modified 12/30/2020 9:18 am by msbannister373603 | 1068 views | 6 replies

12/28/2020 9:31 amRay BorduinWebAssist

I need to understand your database structure better to help write the correct query and make sure I'm leading you down the correct path.

What does the Games table have in it? It looks like it already has an oppo1 and oppo2... so what do you get with just select * from games?

I think if I understand the columns in the games table better then I can probably help you write the correct query.

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.