hi there,
when i am processing my search i am getting a series of commas as the result whenrun on the site. When the query is run in mysql it returns no results.
Heres my query:
SELECT barristers.lst_name, barristers.fst_name, barristers.prefered, areas.area FROM barristers, areas WHERE barristers.Lst_name LIKE '%$bar_search%' OR barristers.Fst_name LIKE '%$bar_search%' OR barristers.prefered LIKE '%$bar_search%'
thanks for all your help
ad
when i am processing my search i am getting a series of commas as the result whenrun on the site. When the query is run in mysql it returns no results.
Heres my query:
SELECT barristers.lst_name, barristers.fst_name, barristers.prefered, areas.area FROM barristers, areas WHERE barristers.Lst_name LIKE '%$bar_search%' OR barristers.Fst_name LIKE '%$bar_search%' OR barristers.prefered LIKE '%$bar_search%'
thanks for all your help
ad