the total number of searh results

[Jimmy_xx]

Hey everyone, in the past when I've written searches they have been for small sites, I'm searching a site with around 120,000 entries on a database - its a full text search too :eek:

Ive realised a lot of the time wasted on the search comes from a mini query I do before I do the actual query. Because I only want to show 10 results per page I use the LIMIT in the query to take sections of the array.But as this will only return 10 values I can't find out how many results i have in total using mysql_num_rows()! So i usually have a mini query above just selecting ID values which I use to grab the number of rows before conducting the actual query to collect the data with a set LIMIT.

This mini query just selecting ID values is taking a couple of seconds to execute, Does anyone know how I could just grab the number of results there would be if I didnt use the LIMIT function, without having to use an extra query?

thanks so much!

[devinemke]

use the COUNT() aggregate function

[Jimmy_xx]

but if I count() the array containing the MYSQL_FETCH_ROW - it will only return 10 results due to the LIMIT statement? I'm trying to return the total number of results if I didn't use the limit statement.

[devinemke]

no, i don't mean this [man]count[/man]...i mean this count

[Jimmy_xx]

ah okay, cool cheers. am I right in thinking I run this as a seperate query above the query which fetches the data?

is this much faster? cheers

[Weedpacket]

Yes, and yes.