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?

chasiv

You're running your update & insert query inside your loop that cycles through the records... rather then loop through the records try something like this:

$strSQL = "SELECT usp_tracking_number,us_id from am_ups_shipment_package_reference WHERE Tracking_Number = '$tn')";
$result = mysql_query($strSQL);
$rows = mysql_num_rows($result);
If($rows ==0) { // then no records exists
     <insert query here>;
} else {
     <Update query here>;
}

I think that's what you're looking for...