jxrd Posted June 11, 2009 Share Posted June 11, 2009 Hello, once again, Just another quick question - if I have a query that uses COUNT() and then I check if any restults are returned with mysql_num_rows(), it always returns true, because COUNT() returns 0, which is a result...apparently. Is there a way that I can only return the COUNT if it's greater than 0? I tried this: SELECT IF(COUNT(*) > 0, COUNT(*), '') But it doesn't seem to work. It's not really as simple as this in reality, I have a join, so I can't just check by testing if COUNT(*) is greater than 0. Any help is greatly appreciated. Quote Link to comment Share on other sites More sharing options...
fenway Posted June 11, 2009 Share Posted June 11, 2009 You can check the output of COUNT() in a HAVING clause. Quote Link to comment Share on other sites More sharing options...
jxrd Posted June 11, 2009 Author Share Posted June 11, 2009 You're a genius fenway I never knew that even existed... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.