Forum Moderators: open
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
i do have a line that includes 'xmen' in inf_name, an exact match to 'movies' in inf_cat and an exact match to 'Other' in inf_scat.. and the command works as it should until my php page generates:
and inf_cat = 'movies' and inf_scat = 'Other'
in the select line. am i doing this incorrectly? :¦
any help would be appreciated.
first you should determine if it's a mysql problem or a php problem.
have you tried that query in the mysql command line tool?