stoping empty values to be inserted

[ferhanz]

let say i have a form asking user to enter its expertise....i have given him three form fields to enter those...right now i have put the insert query for every form field and even if he enters in two of them .3 records are entered in the DB , one of course emtpy..how could i code so that only filled form fileds should be inserted.

Thanks

[omoutop]

hi!
maybe u can try something like this:

supposing u have 3 variables to store: $var1, $var2, $var3...
and there are 3 fields in the db: field1, field2, field3...

/////////////////////////////////////////////
if ($var1)
{
$query1 = "insert into Database ('field1') VALUES ('".$var1."')";
$result1 = mysql_query($query1);
}
if ($var2)
{
$query2 = "insert into Database ('field2') VALUES ('".$var2."')";
$result2 = mysql_query($query2);
}
if ($var3)
{
$query3 = "insert into Database ('field3') VALUES ('".$var3."')";
$result3 = mysql_query($query3);
}
try that.....
if it dsnt work try (field1)..instead of ('field1')...
(cant remember syntax right now...)
Hope the best

[ferhanz]

thanks buddy
will try it and let u know

[omoutop]

try that:

if ($var1 == '') ///instead of if ($var1)
{

}
/////else if $var1 is not empty////////
else
{
$query1 = "insert into Database ('field1') VALUES ('".$var1."')";
$result1 = mysql_query($query1);
}

PS: if ($var1 == '') two single quotes not one double!