loop problem

[smilesmita]

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?

[Daukan]

$tuple["Tracking Number"] should be $tuple[0] since fetch_row retrieves with a numbered index.

 

Make sure all variables are set.

Place

error_reporting(0);

at the beginning of your script.

 

[kratsg]

Can you get all the different tracking numbers as an array? If so, use the following

 

if(in_array($number_to_check,$array_of_tracking_numbers)){//it was found, so just update
//update
} else {//it was not found, so we add
/add
}

[teng84]

weird

for ( $i = 0;[b] $rd && $i < $rd->Row_Count()[/b]; $i++ ) {