Loading...


bookmark - Mysql Result Problem mysql sending back no results for select statement

Mysql Result Problem - mysql sending back no results for select statement

 
 Discussion by jaruba with 2 Replies.
 Last Update: June 12, 2009, 2:04 am
 
bookmark - Mysql Result Problem mysql sending back no results for select statement  
Quickly Post to Mysql Result Problem mysql sending back no results for select statement w/o signup Share Info about Mysql Result Problem mysql sending back no results for select statement using Facebook, Twitter etc. email your friend about Mysql Result Problem mysql sending back no results for select statement Print
Reply / Comment New Discussion / Topic Share / Bookmark E-Mail a Friend Print

this line:

CODE

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.






   Tue May 12, 2009    Reply         

Use that query inside the phpmyadmin SQL tab to see what results are generated.

   Tue May 12, 2009    Reply         

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 query
select * 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





   Fri Jun 12, 2009    Reply         


Quickly Post to Mysql Result Problem mysql sending back no results for select statement w/o signup Share Info about Mysql Result Problem mysql sending back no results for select statement using Facebook, Twitter etc. email your friend about Mysql Result Problem mysql sending back no results for select statement Print
Reply / Comment New Discussion / Topic Share / Bookmark E-Mail a Friend Print

Similar Topics:

Submitting A Form In Flex follow U...

Now Saint Michael made an excellent 3 part tutorial that explains how to make a form HERE So if you need to design a form follow his nice tutorial. He did however mention he didnt know (yet) how to submit a form, s ...more

   23-Sep-2008    Reply         

Logo Design

Hey guys I've decided myself to show you how a proffesional logo design should be made.For our work we need two softwares, imagination and a bit of knowledge in designing. Wee need Adobe Illustrator and Photoshop to complete our tutorial. I know not many people has Illustrator so I've ...more

   04-Apr-2009    Reply         

Making A Simple Platformer In Game ...

Tutorial: Making a simple platformer in Game Maker. (I know this is a tutorial, but it's directly linked in with Game Development, so I wasn't sure which forum to post it in. I hope this is okay.) ________________________________________ This tu ...more

   10-Sep-2009    Reply         

Joomla - Upload Template Built Localhost To The Server    Joomla - Upload Template Built Localhost To The Server (3) (2) Need To Outsource Online Game Development, Cartoon Style Educational Games Tips? Can you do it?  Need To Outsource Online Game Development, Cartoon Style Educational Games Tips? Can you do it?