[SOLVED] Form and Database help

[PrinceOfDragons]

What is the simplest way to exclude empty $_POST[''] from updating a database  instead of writing an if statement for each variable that’s needs to be updated ?

[Garethp]

$SQL1 = "";
$SQL2 = "";

foreach($_POST as $k=>$v)
{
if(empty($v))
	{
	continue;
	}

$SQL1 .= "`$k`, ";
$SQL2 .= "'$v', ";
}

$SQL1 = substr($SQL1, 0, -2);
$SQL2 = substr($SQL2, 0, -2);

$SQL = "INSERT INTO `Table` ($SQL1)
VALUES ($SQL2)";
mysql_query($SQL);

[PrinceOfDragons]

Thank You It Worked, but i had to remove the single quotes from the following line.

 

$SQL1 .= "$k, ";
$SQL2 .= "$v, ";