jason97673 Posted August 23, 2007 Share Posted August 23, 2007 Hello, I am trying to search mutiple tables in my PHP code. I believe I only need to get the query correct. Basically I have maybe 5 table where I need t oselect all the data from them but I only want to search one of the fields in each of those tables. I have something like " SELECT * from movies, music, hats, books, WHERE movies.name, music.album, hats.upc, books.title like '%$search%'" Obviously the variable search is specified in the PHP when someone types in a keyword then hits search. Anyone can help? Thanks Link to comment https://forums.phpfreaks.com/topic/66413-search-multiple-tables/ Share on other sites More sharing options...
jvrothjr Posted August 24, 2007 Share Posted August 24, 2007 look in to join function Link to comment https://forums.phpfreaks.com/topic/66413-search-multiple-tables/#findComment-332582 Share on other sites More sharing options...
Barand Posted August 25, 2007 Share Posted August 25, 2007 Closed - double posted Link to comment https://forums.phpfreaks.com/topic/66413-search-multiple-tables/#findComment-333754 Share on other sites More sharing options...
Recommended Posts