<?php

	$host = 'localhost';
	$username = 'root';
	$password = '';
	$database = 'xscommerce';
	$link = mysql_connect($host, $username, $password);
	$db = mysql_select_db($database, $link);
	if (!$db) {
    	die('Could not connect: ' . mysql_error());
	}
	//echo 'Connected successfully';

	$lines = file('watch33.txt');

	foreach ($lines as $line_num => $line) {
    	//echo "Line #<b>{$line_num}</b> : " . htmlspecialchars($line) . "<br />\n";
    	$fields = explode("	", $line);
    	echo $fields[0]."<br />\n";
    	$sql = "SELECT * FROM `watches` WHERE SKU = \"".$fields[0]."\" LIMIT 0 , 30";
    	echo $sql."<br />\n";
    	$sqlquery = mysql_query($sql, $link);
		while ($row = mysql_fetch_assoc($sqlquery)) {
    		echo $row['SKU'];
		}
	}

	//$load="LOAD DATA INFILE 'C:\wamp\www\SQL\watch33.txt' REPLACE INTO TABLE watch33";
	//mysql_query($load);

	mysql_close($link);
?>