Help us test the new Databridge BETA with MySQLi support

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 10:16 am by stephen287384 | Last modified 1/19/2016 12:39 am by stephen287384 | 648 views | 11 replies

1/18/2016 10:16 amstephen287384

Select from multiple tables for search filter from single text field

I need a text field "keywords" to deliver results from multiple tables. Here is the Query so far which is throwing errors:

SELECT UserArtistName,UserBandName, UserBusinessName, UserInfluences AS 'who' FROM users UNION SELECT AlbumTitle, AlbumTrack1, AlbumTrack2, AlbumTrack3, AlbumTrack4, AlbumTrack5, AlbumTrack6, AlbumTrack7, AlbumTrack8, AlbumTrack9, AlbumTrack10, AlbumTrack11, AlbumTrack12, AlbumTrack13, AlbumTrack14, AlbumTrack15, AlbumTrack16, AlbumTrack17, AlbumTrack18, AlbumTrack19, AlbumTrack20 AS 'what' FROM discography WHERE ('who' LIKE ? OR 'what' LIKE ?) OR UserGenreID = ? OR UserState = ?
$rsResults->bindParam("cl", "".(isset($_POST['keyword'])?$_POST['keyword']:"") ."", "-1"); //paramKeywords
$rsResults->bindParam("i", "".(isset($_POST['genre'])?$_POST['genre']:"") ."", "-1"); //paramGenre
$rsResults->bindParam("s", "".(isset($_POST['state'])?$_POST['state']:"") ."", "-1"); //paramState

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.