this line:
select * from fusion_tor_info where (inf_name like '%xmen%' or inf_desc like '%xmen%' or inf_loc like '%xmen%' ) and inf_cat = 'movies' and inf_scat = 'Other' order by inf_seeds DESC
seems to not get any results from mysql, it works fine until my php page generates the and inf_cat = 'movies' and inf_scat = 'Other'.
i indeed have a line that has xmen in the inf_name col, movies in inf_cat and Other in inf_scat. is there an error in my select query? any help would be appreciated.