<?
$usql="UPDATE MasterAccounts SET ";
$sql="Select * from MasterAccounts WHERE CustomerID=".$CustomerID;
include "mysql.inc.php";
$result = mysql_query($sql);
$res2 = mysql_query($sql);
#$row=mysql_fetch_row($result);
$r = mysql_fetch_array($result);
#mysql_data_seek($result,0);
$i=0;
#while (list ($field->name,$val) = each ($r)){
while ($field=mysql_fetch_field($res2)) {
#echo "$field->name";
reset($HTTP_POST_VARS);
#print "$field->name: $val<BR>\n";
if ($HTTP_POST_VARS[$field->name] != $row[$field->name])
{
$echo.= "<B>$field->name</B>".$HTTP_POST_VARS[$field->name]." ";
if ($r[$field->name] != $HTTP_POST_VARS[$field->name]){
$var=$field->name;
$change.=$field->name.":".$r[$field->name]."->".$HTTP_POST_VARS[$field->name]."\n";
#echo "was <B>$row[$i]</B>";
$usql=$usql."$field->name='".$HTTP_POST_VARS[$field->name]."', ";
}
#echo "<BR>";
}
else
{
$echo.= "<I>$field->name</I>".$HTTP_POST_VARS[$field->name]."<BR>";
}
$i++;
}
if ($CustomerID>0 and strlen($usql)>21)
{
$usql=$usql."LastModifyDate=Now(), ";
$usql.="LastModifyUser='$PHP_AUTH_USER', ";
$usql=substr($usql,0,strlen($usql)-2);
$usql=$usql." WHERE CustomerID=$CustomerID";
$echo.= $usql;
if (mysql_query($usql))
{
$echo.= "<BR><B>UPDATED</B>";
$csql = "INSERT INTO Changes(ChangeUser, ChangeDate, ChangeText,CustomerID, IPAddress)
VALUES('$PHP_AUTH_USER', now(), '$change',$CustomerID,'$REMOTE_ADDR')";
mysql_query($csql);
if ($debug)
print $echo;
else{
header ("Location: user.php");
exit;
}
}
else
print "<BR><B>Save Error</B>.<BR>$echo";
}
#echo "<BR>";
#$row=mysql_fetch_array($result);
if ($HTTP_POST_VARS)
{
for(reset($HTTP_POST_VARS); $key = key($HTTP_POST_VARS);
next($HTTP_POST_VARS))
{
if (is_array($HTTP_POST_VARS[$key]))
{
$num=count($HTTP_POST_VARS[$key]);
for ($i=0; $i<$num; $i++)
#print "$$key". "[$i] =".$HTTP_POST_VARS[$key][$i]."<br>\n";
while ($field=mysql_fetch_field($result))
{
if ($field->name == $key)
{
#print "<B>".$field->name."</B>";
}
}
}
else
{
#print "$$key = ".$HTTP_POST_VARS[$key]. "<br>\n";
}
}
}
# print "<hr>";
?>