[Resolved] Problem with MySQL Query

[ow-phil]

Hi All. I am trying to search two tables in one query. Below is the query I have written, which is not throwing any errors, but it is not returning any data, even though there is data there.

Any help would be appreciated.

Thanks in Advance,

Phil

$dbquery_total = "SELECT * FROM itemmaster,songs WHERE songs.itemcode LIKE '%$txt_searchstring%' OR songs.song_name LIKE '%$txt_searchstring%' OR songs.song_artist LIKE '%$txt_searchstring%' OR songs.song_notes LIKE '%$txt_searchstring%' OR itemmaster.itemcode LIKE '%$txt_searchstring%' OR itemmaster.itemname LIKE '%$txt_searchstring%' OR itemmaster.itemsubname LIKE '%$txt_searchstring%' OR itemmaster.itempublisher LIKE '%$txt_searchstring%' OR itemmaster.itemauthor LIKE '%$txt_searchstring%' OR itemmaster.itemdescription LIKE '%$txt_searchstring%'";