Re: FN-FORUM MySQL query

date posted 29th January 2003 15:41

not sure exactly what you're trying to do here. if you know the position of
the record already then im sure PHP will have an equivalent of ASP's
absoluteposition.

however since you've retrieved that position from some process prior to this
why not extract the id field of the table then you only have to retrieve one
record with 'WHERE idfieldname='?
----- Original Message -----
From: "Richard Watt" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Wednesday, January 29, 2003 1:30 PM
Subject: FN-FORUM MySQL query


> I'm having problems writing a SQL query that extracts the position of
> a record in a sorted table without actually fetching the entire list
> of records (potentially very large list) and doing some nasty
> processor intensive looping in PHP.
>
> Anyone know a quick and dirty way of doing this, or will I have to do
> lots of processing in PHP to calculate positions?
>
> ---------------------------
> Richard Watt Website Design
> site : http://www.rwatt.co.uk
> email : [EMAIL REMOVED]
> phone : (0131) 466 0700
> fax : (0131) 466 1813
>
> ========
> Freelancers and Freelance Jobs: http://www.freelancers.net
>
> Advertise with Freelancers.net http://www.freelancers.net/advert.php
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
[EMAIL REMOVED]