Query Limits

[dmeeroff]

I am finalizing a real estate page, and our listing page does everything we want, but it won't show past 10 pages or 100 listings.

 

If anyone can give me any pointers, please let me know.

 

Here is the page live: http://www.dangelorealty.com/listingsNW91.php

 

The code is attached.

 

Diego

 

[attachment deleted by admin]

[ChemicalBliss]

		$result = mysql_query($sql);

 

Echo the $sql before the query, make sure it is exactly what it is supposed to be, make sure it works in phpmyadmin etc. If the results are getting through to php, then there is a problem with your display code rather than your query.

 

-CB-

[Buddski]

This is the default of your switch statement correct?

As I said in your last topic..

 

Your count query is going to return more rows than your fetching query as your where clause in your fetching query has MORE conditions to it..

ie

You count query only checks for enabled = Y (which might be 120 records)

whereas your fetching query checks that the status is not Leased or For Lease.. Which may only return 90 rows..

So basically your buttons are expecting 120 records to be available but you are only giving it 90 to display...