Jump to content
xisto Community
jaruba

Mysql Result Problem mysql sending back no results for select statement

Recommended Posts

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.

Share this post


Link to post
Share on other sites

Hi!Apparently, everything you've got in the database seems to be in lower case, except for the "O" in "inf_scat = 'Other'". Can you verify that your capitalization is correct?Run the query:select * from fusion_tor_info where inf_cat = 'movies'and the queryselect * from fusion_tor_info where inf_scat = 'Other'to determine if you get any results.If both queries work fine and, as you've mentioned, the query also works fine without adding the two additional conditions in the where clause then you probably just don't have "xmen" within the Movies - Other category. Check your data and reply back to the thread if you're still have an issue with it.Regards,Nitin Reddy

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.