[bexlhoward1]

If i try to use that then i get the error : mysql_num_rows(): supplied argument is not a valid MySQL result resource.

The reason I was using COUNT is because I am using Access not MySQL. I think this is the reason I am getting the error if I try using mysql_num_rows.

[skyhawk133]

Arrrg, I'm sorry:

http://us4.php.net/m...bc-num-rows.php

That work??

[bexlhoward1]

I dont think so as I am using ADODB. I have tried PO_Rowcount but I cannot get that to work either.

[Amadeus]

$rs2 is a recordset...you'll have to access the correct member. Try modifying your count query to something like

$resultcount = "SELECT COUNT(propertyID) as totalcount FROM property WHERE propertytype = '".$propertyrequired."' AND area='".$area."' AND bedrooms = '".$bedrooms."' AND price <= '".$budget."' ORDER BY '".$address3."'";

Once the results of that query have been assigned to $rs2, access the $rs2("totalcount") field. Also, you should just be able to use COUNT(*) unless you're trying to do something else with propertyID.

[bexlhoward1]

Hi, I have tried this and I get the error: "Call to undefined function". The code I used is:

$resultcount = "SELECT COUNT(*) as totalcount FROM property WHERE propertytype = '".$propertyrequired."' AND area='".$area."' AND bedrooms = '".$bedrooms."' AND price <= '".$budget."' ORDER BY '".$address3."'";

$finalrowcount=$rs2("totalcount");

print"$finalrowcount"; 

Am I trying to access it wrongly?

Thanks.

[Amadeus]

$rs['totalcount']

my bad, when I was typing it, it was meant as an example of the property, not the real syntax.

Or even $rs->Fields[0]->Value

[bexlhoward1]

Hi, thank you so much. $finalrowcount=$rs->Fields[0]->Value; worked however accessing it using $finalrowcount=$rs['totalcount'] would not.

Back to the final question however (one solution at a time :-) ), I have data in the $rs array, is it best to call the first 10 results from the array rather than the SQL for the pagination? If so, should the SQL just call the IDs so they are stored in the array and then connect to the database again to pull out the results based on the IDs in the array?

If that makes sence?

Thanks.

[skyhawk133]

Lately, I've been using the last method... depending on the number of records it may be quicker to just run a bunch of little queries, rather than trying to store and loop through 300+ records.