[SQL] Counting Row

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,

Reply via email to