I want to make my existing search code search more than 1 table, I have this:
Code: Select all
$query = "select * from herbs where herbName like \"%$trimmed%\" OR herbLatinName like \"%$trimmed%\"
order by herbName";Code: Select all
$query = "select * from herbs where herbName like \"%$trimmed%\" OR herbLatinName like \"%$trimmed%\"
order by herbName and select * from ailments where ailmentName like \"%$trimmed%\" OR explanation like \"%$trimmed%\"
order by ailmentName ";thanx