Re: Counting Row

I understand you need to count of tickets smaller than $recid given
[CONDITION], in that case:

$sql="select count(*) from [MYTABLE] where [CONDITION] and ticketnumber <="
.$recid ;

On 7/21/05, Ricky Sutanto <ricky(at)connexiasolutions(dot)com> wrote:
>
> Hi postgre people. Can anybody help to fix performance of my query?
>
> Let say, I have *n* number of queue ticket. (Which I use SELECT).
>
> Is there faster method to know where is my ticket number in queue?
>
> I use (while in PHP script ) and count one by one until my ticket number
> match with row field .
>
> $sql="select * from [MYTABLE] where [CONDITION] order by [FIELDORDER];
>
> $rs=&$ctclink->Execute($sql);
>
> $ctr=1;
>
> $pos=0;
>
> while (!$rs->EOF) {
>
> if ($rs->fields[0]==$recid) {
>
> $pos=$ctr;
>
> break;
>
> } else {
>
> $ctr++;
>
> $rs->MoveNext(); }
>
> }
>
> print $pos
>
> is there any method to do that with simple??
>
> *Thanks,*
>
>