Jump to content

[SOLVED] mysql_num_rows and COUNT()


jxrd

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

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.