Chinese Zodiac Sign Compatibility

"; // set this to "" if you don't want a bold header $headerweight2 = ""; // set this to "" if you don't want a bold header $background = "#FFFFFF"; //set the pages background color $signimageborder = "2"; //set the animal sign image border size -- 0 = no border $date1 = $year1.$month1.$day1; $birthdate1 = " (Birthdate: ".$month1." ".$day1.", ".$year1.") "; $date2 = $year2.$month2.$day2; $birthdate2 = " (Birthdate: ".$month2." ".$day2.", ".$year2.") "; $con= @mysql_connect("$host","$user","$pass"); if(!$con) { $connect_error = "Failed at mysql_connect. "; echo"error at db connect"; exit(); } $query = "SELECT * FROM chastro,signs WHERE ((date1 <= '$date1' AND date2 >= '$date1') AND chastro.sign = signs.signs)"; $result = @mysql_db_query($db, $query); //echo mysql_errno().": ".mysql_error()."
"; if(!$result) { $query_error = "Failed at the mysql_db_query. 1"; echo"$query_error"; exit(); } else { $r = mysql_fetch_array($result); $person1 = $r["sign"]; $description1 = $r["description"]; $symbol1 = $r["symbol"]; $image1 = $r["image"]; $header1 = $r["header"]; $people1 = $r["people"]; $jobs1 = $r["jobs"]; $compat1 = $r["compat"]; $numbers1 = $r["numbers"]; $westsign1 = $r["westsign"]; $plural1 = $r["plural"]; } $query = "SELECT * FROM chastro,signs WHERE ((date1 <= '$date2' AND date2 >= '$date2') AND chastro.sign = signs.signs)"; $result = @mysql_db_query($db, $query); if(!$result) { $query_error = "Failed at the mysql_db_query. 2"; echo"$query_error"; exit(); } else { $r = mysql_fetch_array($result); $person2 = $r["sign"]; $description2 = $r["description"]; $symbol2 = $r["symbol"]; $image2 = $r["image"]; $header2 = $r["header"]; $people2 = $r["people"]; $jobs2 = $r["jobs"]; $compat2 = $r["compat"]; $numbers2 = $r["numbers"]; $westsign2 = $r["westsign"]; $plural2 = $r["plural"]; } if($person1 == $person2) { $query = "SELECT * FROM matches WHERE ('$person1' = sign1 and '$person1' = sign2)"; } else { $query = "SELECT * FROM matches WHERE (('$person1' = sign1 or '$person1' = sign2) AND ('$person2' = sign1 or '$person2' = sign2))"; } //$query = "SELECT * FROM matches WHERE ('$person1a' = sign1 and '$person2a' = sign2)"; $result = @mysql_db_query($db, $query); if(!$result) { $query_error = "Failed at the mysql_db_query. 3"; echo"$query_error"; exit(); } else { $r = mysql_fetch_array($result); $match = $r["m_descript"]; } ?>