Untitled

<html>
 <body>
<?php
$db_host = "localhost";
$db_user = "user";
$db_password = "password";
$db_name = "tbname";

$connection = mysql_connect($db_host, $db_user, $db_password) or die("error with connection");
mysql_select_db($db_name, $connection);

function update($a,$b)
{
$total = $a - $b;
return $total;
}
$file=fopen("daily_user_summary.txt","r");

while (!feof($file_handle) ) {
$line_of_text = fgets($file);
$parts = explode(' ', $line_of_text);
print $parts[0]. $parts[1]. $parts[2] . $parts[3]. "<BR>";
$query = ("SELECT name,newcredit,sum(total),team FROM tb1 WHERE NAME = '$parts[0]' and TEAM = '$parts[3]'");
$row = mysql_fetch_row($query);
$row['name'] = $name;
$row['newcredit'] = $oldcredit;
$row['sum(total)'] = $oldwu;
$row['team'] = $team;

update($parts[1],$oldcredit) = $newcredit;
$newcredit = $hourcreditupdate;
update($parts[2],$oldwu) = $newwu;
$newwu = $hourwuupdate;
$updatequery = ("UPDATE tb1 SET newcredit='$parts[1]' AND sum(total)='$parts[2]'
WHERE NAME = '$parts[0]' and TEAM = '$parts[3]'");

}
 fclose($file);
 ?>

</body>
</html>