//require("dbconnect.php");
include('info.config');
include('utility/utility.php');
if (isset($_GET["login"])) {$login=$_GET["login"];}
elseif (isset($_POST["login"])) {$login=$_POST["login"];}
if (isset($_GET["sign"])) {$sign=$_GET["sign"];}
elseif (isset($_POST["sign"])) {$sign=$_POST["sign"];}
if($sign != 1)
{
$connection = mysql_connect($host, $user,$password) or die ("Could not connect to server.");
$db = mysql_select_db($database, $connection) or die ("Could not select database.");
$stmt="select * from essen_member where email='$login';";
//echo "$stmt";
$rslt=mysql_query($stmt) or die("Could not execute query.");
//$row=mysql_fetch_row($rslt);
if ($rslt)
{
$status_to_print=mysql_num_rows($rslt);
$row=mysql_fetch_row($rslt);
}
if($status_to_print>0)
{
$frmtitle = $row[3];
$frmfirstname = $row[4];
$frmlastname = $row[5];
$frmaddress = $row[6];
$frmaddress2 = $row[7];
$frmcity = $row[8];
$frmstate = $row[9];
$frmzip = $row[10];
$frmcountry = $row[11];
$frmcompany = $row[12];
$frmdesig = $row[13];
$frmtelephone1 = $row[14];
$frmtelephone2 = $row[15];
$frmtelephone = $row[16];
$frmfax1 = $row[17];
$frmfax2 = $row[18];
$frmfax = $row[19];
$frmdob = $row[20];
$dob=split("/",$frmdob);
//print_r $dob;
$frmyear = $dob[0];
$frmmonth = $dob[1];
$frmdate = $dob[2];
$frmemail = $row[21];
$frmpass = $row[22];
$sign = 0;
}
}
else
{
$frmtitle = "";
$frmfirstname = "";
$frmlastname = "";
$frmaddress = "";
$frmaddress2 = "";
$frmcity = "";
$frmstate = "";
$frmzip = "";
$frmcountry = "";
$frmcompany = "";
$frmdesig = "";
$frmtelephone = "";
$frmfax = "";
$frmdob = "";
$frmemail = "";
$frmpass = "";
}
?>
Essen
|
|
|
Library Subscription *All fields required |
|
|
|
|
|
|