<?
include("Config.php");
include("BDMySql.php");
include("Ges_Table.php");

$bd = new BDMySQL();
$campos = $bd->select(GesTable::qryCampos($table,$dbname),true);
$key = GesTable::primaryKey($campos);

$upd =
	"UPDATE ".$table." SET ";
	
foreach ($campos as $c) { 
	eval("\$valor = "."\$campo_"."$c[Field];");
	if ($valor=="")
		$upd.="$c[Field] = null,";
	else if (strpos($c["Type"],"int")!==false)
		$upd.="$c[Field] = ".$valor.",";
	else if (strpos($c["Type"],"decimal")!==false)
		$upd.="$c[Field] = ".$valor.",";
	else  // las cadenas, fechas y horas van entre ''
		$upd.="$c[Field] = '".$valor."',";
}
$upd = substr($upd,0,strlen($upd)-1); // quitar ultima coma
	
$upd .= 
	" WHERE ";
	
$j=0;
foreach ($campos as $c) { 
	if ($key[$j]) {
		eval("\$valor = "."\$key_"."$c[Field];");
	
		if ($valor=="")
			$upd.= "$c[Field] IS Null AND ";
		else if (strpos($c["Type"],"int")!==false)
			$upd.= "$c[Field] = ".$valor." AND ";
		else if (strpos($c["Type"],"decimal")!==false)
			$upd.= "$c[Field] = ".$valor." AND ";
		else  // las cadenas, fechas y horas van entre ''
			$upd.= "$c[Field] = '".$valor."' AND ";
	}
	$j++;
}
$upd = substr($upd,0,strlen($upd)-4); // quitar el ultimo AND

//echo $upd."<br>"; exit;

$bd->execSql($upd);
$bd->cierraConexion();

$incremento = isset($increment)?"&increment=$increment":"";
$orden = isset($order)?"&order=$order":"";
$cabecera = isset($cabecera)?"&cabecera=$cabecera":"";
$link = isset($link)?"&link=$link":"";
header("Location: Table.php?table=$table&dbname=$dbname$orden$incremento$cabecera$link");
?>