Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › MySQLi Server Behaviors › MySQLI Server Behaviors General / Announcements › Select from multiple tables for search filter from single text field

View all replies to this thread

Select from multiple tables for search filter from single text field

Thread began 1/18/2016 7:16 am by stephen287384 | Last modified 1/18/2016 9:39 pm by stephen287384 | 2817 views | 11 replies

1/18/2016 4:26 pmRay BorduinWebAssist

I don't know what you are trying to do... a UNION SELECT should have the same columns as the initial select... so the entire query seems odd to me.

I'm pretty sure you don't want a UNION SELECT at all. In some cases it makes more sense to use two Recordsets.

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.