Help with update table script

[affordit]

OK I have no idea why this will not update the table but here is the code I wrote. I just can't see it 

<?php
//CONNECT TO DATABASE
include("sharons_dbinfo.inc.php");
mysql_connect(localhost,$user,$password);
mysql_select_db($database) or die( "Unable to select database");

//OPEN THE ZIP FILE
$handle = gzopen('Newegg_com-Daily_Deals_Feed.txt.gz', 'r');

//READ THE WHOLE FILE LINE BY LINE
while (!gzeof($handle)) {
$buffer = gzgets($handle, 4096);
$buffer = str_replace("'" , "" , $buffer);
$buffer = str_replace("\"" , "" , $buffer);
$data = explode(",", $buffer);

//SKIP THE FIRST LINE OF COLUMN NAMES
if ($data[4] == "NAME"){}
else{
					//PUT THIS IN TO MAKE SURE IT WAS LOOKING FOR THE RIGHT RECORD
					print "Looking for: ". $data['4'] . " to update with new date " . $data['3']."<br>";
	$item_name = $data['4'];
//QUERY THE TABLE FOR PRODUCT NAME FROM ZIP FILE
	$query = ("SELECT * FROM `computer_memory` WHERE `NAME` = '$item_name'");
	$results = mysql_query($query) or die(mysql_error()."<br /><br />".$query);
	$result = mysql_fetch_array($results);
	$num=mysql_numrows($results);
	//IF THE NAME EXISTS PROCEED TO UPDATE THE RECORD WITH THE NEW INFORMATION
	if ($num >0) {

//UPDATE TABLE WITH THE NEW INFORMATION
$update = ("UPDATE `computer_memory` SET
`PROGRAMNAME`= '$data[0]',
`PROGRAMURL`= '$data[1]',
`CATALOGNAME`= '$data[2]',
`LASTUPDATED`= '$data[3]',
`NAME`= '$data[4]',
`KEYWORDS`= '$data[5]',
`DESCRIPTION`= '$data[6]',
`SKU`= '$data[7]',
`MANUFACTURER`= '$data[8]',
`MANUFACTURERID`= '$data[9]',
`UPC`= '$data[10]',
`ISBN`= '$data[11]',
`CURRENCY`= '$data[12]',
`SALEPRICE`= '$data[13]',
`PRICE`= '$data[14]',
`RETAILPRICE`= '$data[15]',
`FROMPRICE`= '$data[16]',
`BUYURL`= '$data[17]',
`IMPRESSIONURL`= '$data[18]',
`IMAGEURL`= '$data[19]',
`ADVERTISERCATEGORY`= '$data[20]',
`THIRDPARTYID`= '$data[21]',
`THIRDPARTYCATEGORY`= '$data[22]',
`AUTHOR`= '$data[23]',
`ARTIST`= '$data[24]',
`TITLE`= '$data[25]',
`PUBLISHER`= '$data[26]',
`LABEL`= '$data[27]',
`FORMAT`= '$data[28]',
`SPECIAL`= '$data[29]',
`GIFT`= '$data[30]',
`PROMOTIONALTEXT`= '$data[31]',
`STARTDATE`= '$data[32]',
`ENDDATE`= '$data[33]',
`OFFLINE`= '$data[34]',
`ONLINE`= '$data[35]',
`INSTOCK`= '$data[36]',
`CONDITION`= '$data[37]',
`WARRANTY`= '$data[38]',
`STANDARDSHIPPINGCOST`= '$data[39]'
WHERE `ID`= '$id'");
mysql_query($update) or die(mysql_error()."<br /><br />".$update);
//if ($update){print "UPDATED ".$result['ID'];}
}else{

//IF THE NAME DID NOT EXIST INSERT A NEW RECORD INTO THE TABLE
$import="INSERT into computer_memory (`ID`,`PROGRAMNAME`,`PROGRAMURL`,`CATALOGNAME`,`LASTUPDATED`,`NAME`,`KEYWORDS`,`DESCRIPTION`,`SKU`,`MANUFACTURER`,`MANUFACTURERID`,`UPC`,`ISBN`,`CURRENCY`,`SALEPRICE`,`PRICE`,`RETAILPRICE`,`FROMPRICE`,`BUYURL`,`IMPRESSIONURL`,`IMAGEURL`,`ADVERTISERCATEGORY`,`THIRDPARTYID`,`THIRDPARTYCATEGORY`,`AUTHOR`,`ARTIST`,`TITLE`,`PUBLISHER`,`LABEL`,`FORMAT`,`SPECIAL`,`GIFT`,`PROMOTIONALTEXT`,`STARTDATE`,`ENDDATE`,`OFFLINE`,`ONLINE`,`INSTOCK`,`CONDITION`,`WARRANTY`,`STANDARDSHIPPINGCOST`) values('','$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]','$data[15]','$data[16]','$data[17]','$data[18]','$data[19]','$data[20]','$data[21]','$data[22]','$data[23]','$data[24]','$data[25]','$data[26]','$data[27]','$data[28]','$data[29]','$data[30]','$data[31]','$data[32]','$data[33]','$data[34]','$data[35]','$data[36]','$data[37]','$data[38]','$data[39]')";

       mysql_query($import) or die(mysql_error());
}
}
}
gzclose($handle);

?>

 

I hope someone can see what I can't

Thanks everyone

[affordit]

When I debug the update section, here is a partial list of the result;

UPDATED 1851 with LAST UPDATED 03/02/2011

UPDATED 1891 with LAST UPDATED 03/02/2011

UPDATED 1853 with LAST UPDATED 03/02/2011

UPDATED 1892 with LAST UPDATED 03/02/2011

UPDATED 1855 with LAST UPDATED 03/03/2011

UPDATED 1856 with LAST UPDATED 03/03/2011

UPDATED 1857 with LAST UPDATED 03/03/2011

UPDATED 1858 with LAST UPDATED 02/26/2011

UPDATED 1859 with LAST UPDATED 03/04/2011

UPDATED 1860 with LAST UPDATED 03/04/2011

UPDATED 1861 with LAST UPDATED 03/04/2011

UPDATED 1862 with LAST UPDATED 03/04/2011

UPDATED 1893 with LAST UPDATED 03/04/2011

UPDATED 1864 with LAST UPDATED 03/04/2011

UPDATED 1864 with LAST UPDATED 03/04/2011

UPDATED 1864 with LAST UPDATED 03/04/2011

UPDATED 1862 with LAST UPDATED 03/04/2011

I can't figure out why it would repeat the same ID??

[affordit]

I solved the problem of the update not working but still need to figure out why the update is repeating the IDs.

Any ideas anyone has would be helpful