RE: [PHP] Previous & Next Navigation

2002-06-03 Thread David Freeman
> The memory footprint of the 3k - 5k of records, even if the > total memory needed for each record is 1k (which it is not), > is 30k - 50k RAM, less than the size of most web pages. The > LIMIT query, running on a slow server to simulate dial-up > connections, takes anywhere from 1.3 to

[PHP] MySQL and GROUP BY

2001-11-20 Thread David Freeman
Hi All, I suspect this really can by done in my SQL query rather than afterwards in PHP but I haven't been able to find a way. I have a table with three fields: 1. First_Name 2. Last_Name 3. Business_Name A row that has a first and last name will not have a business name. A row with a busin

<    1   2   3