there is this Db table

Tracking number description
36 XYZ
46 abc
98 lmn

i have this loop in my php file:
$tn=tracking number/numbers received in a file
$rd = $db->Query("SELECT usp_tracking_number,us_id from am_ups_shipment_package_reference");

  for ( $i = 0; $rd && $i < $rd->Row_Count(); $i++ ) {
       $tuple = $rd->Fetch_Row($i);
if ($tuple["Tracking Number"]==$tn){

update the tables with the new data associated with that tracking number
}
else{

insert the new record

}
}

wht is happening:
if the new tracking number provided in the fils is 98 then

98!=36
insert record 96 in the table
98!=46
insert record 96 in the table

98=98

update

wht is wanted is:
98 is compared against 3 and found that its alaredy present and shud just get updated.

Also if a totally new tn is given..for example 33
it doesnt match with any tracking number and gets inserted 4 times.

any idea wht i am missing?

You don't have to execute loop for determining state of database

1) determine total number of rows in $totRowCount

2) execute following query to find whether you new tn exists in database or not.

$rd="SELECT usp_tracking_number,us_id from am_ups_shipment_package_reference WHERE US_TRANKING_NUMBER=" & $TN

if rd->$row_count=0 //tn not found insert multiple times
{
     //insert rows
     for 0 to $totRowCount
        insert rows;
}
else //update
{
      update where traking no = $tn
}

I don't know why you want to insert 4 times or n times, but i hope above algorithm will help you.

urt