Ok,
I'm trying to put together a script where it checks to see if $c is checked or not, and does something different if it is or not. But I'm getting an error in my code and I can't figure out why?
<?
if ($REQUEST_METHOD=="POST") {
$date = date("Y-m-d");
$published = "NO";
$a = $_POST['owner_save'];
$b = $_POST['contractor_save'];
$c = $_POST['same_as'];
if(isset($c))
{
$project_address = "same as";
if(isset($b))
{
$SQL = " INSERT INTO owners_contractors ";
$SQL = $SQL . "(name, address, city, postalcode, phonenumber) VALUES ";
$SQL = $SQL . " ('$contractor', '$contractor_address', '$contractor_city', '$contractor_postalcode', '$contractor_phonenumber')";
$result = mysql_db_query($db,"$SQL",$connect);
}
if(isset($a))
{
$SQL2 = " INSERT INTO owners_contractors ";
$SQL2 = $SQL2 . "(name, address, city, postalcode, phonenumber) VALUES ";
$SQL2 = $SQL2 . " ('$owner', '$owner_address', '$owner_city', '$owner_postalcode', '$owner_phonenumber')";
$result2 = mysql_db_query($db,"$SQL2",$connect);
}
$SQL3 = " INSERT INTO southpermits_data ";
$SQL3 = $SQL3 . "(date, area, owner, owner_address, owner_city, owner_postalcode, owner_phonenumber, project_address, project_type, amount, contractor, contractor_address, contractor_city, contractor_postalcode, contractor_phonenumber, published) VALUES ";
$SQL3 = $SQL3 . " ('$date', '$area', '$owner', '$owner_address', '$owner_city', '$owner_postalcode', '$owner_phonenumber', '$project_address', '$project_type', '$amount', '$contractor', '$contractor_address', '$contractor_city', '$contractor_postalcode', '$contractor_phonenumber', '$published')";
$result3 = mysql_db_query($db,"$SQL3",$connect);
if (!$result3) {
echo("ERROR: " . mysql_error() . "\n$SQL3\n");
}else{
echo "<font color=#990000><strong>New data has been added to the database.</stong></font>";
}
if(empty($c))
(
if(isset($b))
{
$SQL = " INSERT INTO owners_contractors ";
$SQL = $SQL . "(name, address, city, postalcode, phonenumber) VALUES ";
$SQL = $SQL . " ('$contractor', '$contractor_address', '$contractor_city', '$contractor_postalcode', '$contractor_phonenumber')";
$result = mysql_db_query($db,"$SQL",$connect);
}
if(isset($a))
{
$SQL2 = " INSERT INTO owners_contractors ";
$SQL2 = $SQL2 . "(name, address, city, postalcode, phonenumber) VALUES ";
$SQL2 = $SQL2 . " ('$owner', '$owner_address', '$owner_city', '$owner_postalcode', '$owner_phonenumber')";
$result2 = mysql_db_query($db,"$SQL2",$connect);
}
$SQL3 = " INSERT INTO southpermits_data ";
$SQL3 = $SQL3 . "(date, area, owner, owner_address, owner_city, owner_postalcode, owner_phonenumber, project_address, project_type, amount, contractor, contractor_address, contractor_city, contractor_postalcode, contractor_phonenumber, published) VALUES ";
$SQL3 = $SQL3 . " ('$date', '$area', '$owner', '$owner_address', '$owner_city', '$owner_postalcode', '$owner_phonenumber', '$project_address', '$project_type', '$amount', '$contractor', '$contractor_address', '$contractor_city', '$contractor_postalcode', '$contractor_phonenumber', '$published')";
$result3 = mysql_db_query($db,"$SQL3",$connect);
if (!$result3) {
echo("ERROR: " . mysql_error() . "\n$SQL3\n");
}else{
echo "<font color=#990000><strong>New data has been added to the database.</stong></font>";
}
}
?>
It's telling me that I have a parse error, somewhere in these lines:
if(empty($c))
(
if(isset($b))
CAN ANYONE HELP ME OUT?
THANKS