Just wondering if there is an easy way to paginate this query ->
$common_fields = 'mlsid, class, class_type, area_id, status,
subdivision, asking_price, agent_name, office_name, address, city,
state, zip';
$query = mysql_query(" SELECT $common_fields FROM listings_commercial
UNION ALL
SELECT $common_fields FROM
listings_land UNION ALL
SELECT $common_fields FROM
listings_residential UNION ALL
SELECT $common_fields FROM
listings_multifamily UNION ALL
SELECT $common_fields FROM
listings_condotownhouse
ORDER BY asking_price LIMIT
10");
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
