I've been searching through PHP and MySQL docs for awhile here and cannot find out how to do what I want to do. What I need to do is find the number of rows that would be returned by a SELECT query, but I need the result of the SELECT to take up (virtually) no memory. I'm trying to find a way to have the SELECT query return empty rows, but the correct number of them so I could just use mysql_num_rows(). I haven't been having any luck though, so maybe I'm just going about it the wrong way and there is a different method which achieves my desired result.
Any help would be much appreciated.
Any help would be much appreciated.