Russ_T

$handle = @fopen("./generatedPostcodes.txt", "r");

//$rowCount = 0;
$lineCount = 0;
$insertCount = 0;

if ($handle) {
    while (!feof($handle)) { // && $lineCount < 100) {
        $buffer = fgets($handle);
		
		$outcode = substr($buffer, 0, 4);		
		$incode = substr($buffer, 4, 3);		
		$introductionDate = substr($buffer, 7, 6);
		$gridReferenceEast = substr($buffer, 13, 5);
		$gridReferenceNorth = substr($buffer, 18, 5);
		$county = substr($buffer, 23, 2);
		$district = substr($buffer, 25, 2);
		$ward = substr($buffer, 27, 2);
		$userType = substr($buffer, 29, 1);
		$gridStatus = substr($buffer, 30, 1);
		$country = substr($buffer, 31, 3);
		$wardStatus = substr($buffer, 34, 1);
		$nhsCode = substr($buffer, 35, 3);
		$nhsRegion = substr($buffer, 38, 3);

		/*$newBuffer = $outcode . "|" . $incode . "|" . $introductionDate . "|" .	$gridReferenceEast . "|" . $gridReferenceNorth . "|" . $county . "|" . $district 
					. "|" . $ward . "|" . $userType . "|" . $gridStatus . "|" .	$country . "|" . $wardStatus . "|" . $nhsCode . "|" . $nhsRegion;*/

		//$rowCount++;

		//echo $rowCount . "- " . $newBuffer ."<br />";

		$lineCount++;

		$sql = 'INSERT INTO `postzon` (`Outcode`, `Incode`, `IntroductionDate`, `GridReferenceEast`, `GridReferenceNorth`, `County`, `District`, `Ward`, '.
				'`UserType`, `GridStatus`, `Country`, `WardStatus`, `NHSCode`, `NHSRegion`) VALUES '.
				'(\''.$outcode.'\', \''.$incode.'\', \''.$introductionDate.'\', \''.$gridReferenceEast.'\', \''.$gridReferenceNorth.'\', \''.$county.'\', \''.
				$district.'\', \''.$ward.'\', \''.$userType.'\', \''.$gridStatus.'\', \''.$country.'\', \''.$wardStatus.'\', \''.$nhsCode.'\', \''.$nhsRegion.'\');';
		//echo $sql;

		$result = mysql_query($sql);

		if ($result == true) {
			$insertCount++;
		}
		
    }
    fclose($handle);
}