Posted by tehllama on 12/28/06 12:54

On Wed, 27 Dec 2006 07:42:41 +0000, David Quinton
<usenet_2005D_email@REMOVETHISBITbizorg.co.uk> wrote:

>On Mon, 25 Dec 2006 17:55:16 +0100, "Stef" <stef.php@gmail.com> wrote:
>
>>As stated in the above answer you probably should use LIMIT and divide the
>>results into pages sorting the records as you please.
>>
>>A small search form probably would solve a lot too.
>
>He stated that main use was to search for duplicates/typos, so might
>also be a nice feature for the users if you make the column headers
>clickable with hrefs.
>Clicks will re-query using that column as the ORDER BY column.
>pretty easy to do and I've found that Admin users quite like the
>feature for looking at "arw" data.

Thanx for your contribution. That is actually a feature of the
present display (clicking on column headings sorts by that column,
name, postcode, service_number, NI_number, etc) so I'll be continuing
that but with the same mysql BETWEEN instruction as the original
Query.

[Back to original message]