Horoscope Reports (Place)

Name:

Birthday:

BirthTime: :[insert_php]if (isset($_POST["BTU"])) {echo "(Sun Rising/Eq Houses)";} else if ($_POST["AP"]=="12") {echo "PM";} else {echo "AM";} [/insert_php]

First choose a Country, then the State(US only):

[insert_php]
$con = mysql_connect("localhost","esther","SDfr38LB");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("PlacesDB", $con);

$ors = mysql_query("SELECT DISTINCT Country FROM Countries ORDER BY Country");
$srs = mysql_query("SELECT DISTINCT State FROM States ORDER BY State");

[/insert_php]

[insert_php]

while($row = mysql_fetch_array($ors))
{
$countryname=$row['Country'];

if ($_POST["countrySelect"]==$countryname)
{

echo "

";
echo $countryname."";

}
else
{

echo "

";
echo $countryname."";

}

}

[/insert_php]

[insert_php]if ($_POST["countrySelect"]=="- US -")
{
echo "";

while($row = mysql_fetch_array($srs))
{
$statename=$row['State'];
if ($_POST["RegionCheck"]==$statename)
{

echo "

";
echo $statename."";

}

else
{

echo "

";
echo $statename."";

}

}

echo "

";
} else {
}
[/insert_php]

Then the city of your birth:

[insert_php]

if ($_POST["countrySelect"]=="- US -")
{

if ($_POST["RegionCheck"]=="")
{

$strText="Alabama";
}
else
{

$strText=$_POST["RegionCheck"];
}
}
else
{
if ($_POST["countrySelect"]=="")
{
$strText="Canada";
}
else
{
$strText=$_POST["countrySelect"];
}
}

$conC = mysql_connect("localhost","esther","SDfr38LB");
if (!$conC)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("PlacesDB", $conC);

$orsC = mysql_query("SELECT City FROM $strText ORDER BY City");

if (!$orsC)
{exit("Error in SQL");}
[/insert_php]

[insert_php]

while($rowC = mysql_fetch_array($orsC))

{
$cityname=$rowC["City"];
echo "

$cityname ";
}
mysql_close($connC);
[/insert_php]

[insert_php]
$US = $_POST["RegionCheck"];
$NOTUS = $_POST["countrySelect"];
if ($_POST["countrySelect"]=="- US -")
{
echo "";
} else {
echo "";
}
[/insert_php]