Can anyone tell me why this doesn't work?
if($contractor !== "") {
$sql12 = "select * from owners_contractors WHERE name = '$contractor'";
if (eregi("$contractor",$name)) {
$result12 = mysql_query($sql12);
$clients = mysql_fetch_array($result12);
$id=$clients['id'];
$contractor=$clients['name'];
$contractor_address=$clients['address'];
$contractor_city=$clients['city'];
$contractor_postalcode1=$clients['postalcode1'];
$contractor_postalcode2=$clients['postalcode2'];
$contractor_phonenumber1=$clients['phonenumber1'];
$contractor_phonenumber2=$clients['phonenumber2'];
$contractor_phonenumber3=$clients['phonenumber3'];
}else{}
}
if($owner !== "") {
$sql11 = "select * from owners_contractors WHERE name = '$owner'";
if (eregi("$owner",$name)) {
$result11 = mysql_query($sql11);
$clients = mysql_fetch_array($result11);
$id=$clients['id'];
$owner=$clients['name'];
$owner_address=$clients['address'];
$owner_city=$clients['city'];
$owner_postalcode1=$clients['postalcode1'];
$owner_postalcode2=$clients['postalcode2'];
$owner_phonenumber1=$clients['phonenumber1'];
$owner_phonenumber2=$clients['phonenumber2'];
$owner_phonenumber3=$clients['phonenumber3'];
}else{}
}
if(isset($c))
{
$contractor = "Self";
$contractor_address = "";
$contractor_city = "";
$contractor_postalcode1 = "";
$contractor_postalcode2 = "";
$contractor_phonenumber1 = "";
$contractor_phonenumber2 = "";
$contractor_phonenumber3 = "";
}
if(isset($d))
{
$SQL = " INSERT INTO areas ";
$SQL = $SQL . "(name) VALUES ";
$SQL = $SQL . " ('$area')";
$result = mysql_db_query($db,"$SQL",$connect);
}
if(isset($b))
{
$SQL = " INSERT INTO owners_contractors ";
$SQL = $SQL . "(name, address, city, postalcode1, postalcode2, phonenumber1, phonenumber2, phonenumber3) VALUES ";
$SQL = $SQL . " ('$contractor', '$contractor_address', '$contractor_city', '$contractor_postalcode1', '$contractor_postalcode2', '$contractor_phonenumber1', '$contractor_phonenumber2', '$contractor_phonenumber3')";
$result = mysql_db_query($db,"$SQL",$connect);
}
if(isset($a))
{
$SQL2 = " INSERT INTO owners_contractors ";
$SQL2 = $SQL2 . "(name, address, city, postalcode1, postalcode2, phonenumber1, phonenumber2, phonenumber3) VALUES ";
$SQL2 = $SQL2 . " ('$owner', '$owner_address', '$owner_city', '$owner_postalcode1', '$owner_postalcode2', '$owner_phonenumber1', '$owner_phonenumber2', '$owner_phonenumber3')";
$result2 = mysql_db_query($db,"$SQL2",$connect);
}
if ($project_type == "x"){$project_type = "";}
if ($contractor == ""){$contractor_city = "";}
$SQL3 = " INSERT INTO southpermits_data ";
$SQL3 = $SQL3 . "(date, area, owner, owner_address, owner_city, owner_postalcode1, owner_postalcode2, owner_phonenumber1, owner_phonenumber2, owner_phonenumber3, project_address, project_type, project_type2, amount, contractor, contractor_address, contractor_city, contractor_postalcode1, contractor_postalcode2, contractor_phonenumber1, contractor_phonenumber2, contractor_phonenumber3, published) VALUES ";
$SQL3 = $SQL3 . " ('$date', '$area', '$owner', '$owner_address', '$owner_city', '$owner_postalcode1', '$owner_postalcode2', '$owner_phonenumber1', '$owner_phonenumber2', '$owner_phonenumber3', '$project_address', '$project_type', '$project_type2', '$amount', '$contractor', '$contractor_address', '$contractor_city', '$contractor_postalcode1', '$contractor_postalcode2', '$contractor_phonenumber1', '$contractor_phonenumber2', '$contractor_phonenumber3', '$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>";
}
$SQL4 = " UPDATE southpermits_data SET";
$SQL4 = $SQL4 . " show = 'on' ";
$SQL4 = $SQL4 . " WHERE area = '$name' ";
if (!$result3) {
echo("ERROR: " . mysql_error() . "\n$SQL4\n");
}else{
echo "<font color=#990000><strong>New data has been added to the database 2.</stong></font>";
}
}
The part that doesn't work is the eregi parts when checking for owners and contractors... also, the last part where i change the value to on, doesn't work either.
