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 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 Share on other sites More sharing options...
Barand Posted August 25, 2007 Share Posted August 25, 2007 Closed - double posted Link to comment Share on other sites More sharing options...
Recommended Posts