I have two tables:
songs: with fields- autoid,itemcode,songname,songartist
itemmaster: with fields- autoid,itemname, itemsubname, itempublisher, itemauthor, itemdescription, price
The main table is products. The results for the products are listed, and if someone chooses more info for a specific product, a DBquery happens to pull up the listing of songs that match the itemcode, if there are any songs that match the itemcode. Not all items are music CD's, some are equipment which would have nothing listed in the songs table.
I have setup a search form. In order to have the search form be as complete as possible, what I want to be able to do is have the searchfield ($txt_searchstring) search the songs table, match anything in that table against $txt_searchstring, give me the itemcode for those songs that match, and then search the products table, matching all columns against $txt_searchstring, and then also searching all of the itemcodes turned in the search of the Songs table.
What I have done sofar is this.
SELECT UNIQUE(itemcode) FROM songs WHERE (match(song_name, song_artist, song_notes) against('$txt_searchstring' IN BOOLEAN MODE))
SELECT * FROM itemmaster WHERE (match(itemname, itemsubname, itempublisher, itemauthor, itemdescription) against('$txt_searchstring' IN BOOLEAN MODE))
Now I am wondering how to get the results from the DBquery of songs to search in the DBquery for itemmaster
Thanks in Advance,
Phil
