Re: [SQL] Counting Row

[Pascual De Ruvo]

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 <[EMAIL PROTECTED]> 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,