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. Link to comment https://forums.phpfreaks.com/topic/161803-solved-mysql_num_rows-and-count/ 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. Link to comment https://forums.phpfreaks.com/topic/161803-solved-mysql_num_rows-and-count/#findComment-853701 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... Link to comment https://forums.phpfreaks.com/topic/161803-solved-mysql_num_rows-and-count/#findComment-853791 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.