Somewhat Simple Count(*) question...

[drbigfresh]

I am trying to get the total # of results returned in my full text query, but I can't seem to figure it out. I think I have tried every variation and it is totally eluding me....

 

Here is the query....

SELECT id, description, MATCH(description) AGAINST('apple') AS score FROM feed WHERE MATCH(description) AGAINST('apple')  ORDER BY score DESC

 

When I just add a count(*) in there it only returns 1.

 

 

Thanks!

[bubblegum.anarchy]

The PHP function mysql_num_rows($result_id) will provide the row count after the query is processed.

[btherl]

If you're using count(*), you should request the first column of the first row of the result.  That will be your count.

 

$count = mysql_result($result, 0, 0);

 

But if you need to run the full query anyway, then mysql_num_rows() is better.  If you don't need to run the full query anyway, count(*) is better.