Hi, thanks for the response,
just so people know how I solved this, here is the basic php code I have used to solve my question.
<?php
// create connection
$username = "xxxx";
$hostname = "localhost";
$password = "xxxx";
$databaseName = "xxxx";
$tableName = "xxxx";
if(!($link=mysql_connect($hostname, $username, $password)))
{
echo("Error connection to database\n");
exit();
}
mysql_select_db("xxxx");
// insert into table
$contents = file("text.txt");
foreach($contents as $line) {
$line = str_replace('"', '', $line);
$fields = explode(',', $line);
$var0 =$fields[0];
$var1= $fields[1]; ;
printf("%s %s<BR>", $var0, $var1);
$updateStmt = "UPDATE tablename SET COLUM2='$var2' WHERE COLUM1='$var0'";
if (!mysql_query($updateStmt, $link)) {
echo("Error updating database\n");
exit();
}
} // end for each
?>
Hope this helps somebody else.
