|
/* declare some relevant variables */
$hostname = "mysql.whiz.to";
$username = "lodging";
$dbpassword = "lodging";
$userstable = "client";
$dbName = "lodging";
/* make connection to database */
MYSQL_CONNECT($hostname, $username, $dbpassword) OR DIE("Unable to connect to database");
@mysql_select_db( "$dbName") or die( "Unable to select database");
$query = "SELECT * FROM $userstable WHERE (link='$link2') ";
$result = MYSQL_QUERY($query);
$number = MYSQL_NUMROWS($result);
$h = 0;
IF ($number == 0) :
PRINT "Error - Contact Admin! ";
ELSEIF ($number > 0) :
WHILE ($i < $number):
$link = mysql_result($result,$i,"link");
$company = mysql_result($result,$i,"company");
$password = mysql_result($result,$i,"password");
$name = mysql_result($result,$i,"name");
$address = mysql_result($result,$i,"address");
$address2 = mysql_result($result,$i,"address2");
$city = mysql_result($result,$i,"city");
$state = mysql_result($result,$i,"state");
$country = mysql_result($result,$i,"country");
$zip = mysql_result($result,$i,"zip");
$notes = mysql_result($result,$i,"notes");
$email = mysql_result($result,$i,"email");
$phone1 = mysql_result($result,$i,"phone1");
$email2 = mysql_result($result,$i,"email2");
$phone2 = mysql_result($result,$i,"phone2");
$email3 = mysql_result($result,$i,"email3");
$phone3 = mysql_result($result,$i,"phone3");
$email12 = mysql_result($result,$i,"email12");
$phone12 = mysql_result($result,$i,"phone12");
$email22 = mysql_result($result,$i,"email22");
$phone22 = mysql_result($result,$i,"phone22");
$email32 = mysql_result($result,$i,"email32");
$phone32 = mysql_result($result,$i,"phone32");
$fax = mysql_result($result,$i,"fax");
$ccname = mysql_result($result,$i,"ccname");
$cctype = mysql_result($result,$i,"cctype");
$ccnumber = mysql_result($result,$i,"ccnumber");
$ccaddress = mysql_result($result,$i,"ccaddress");
$ccyear = mysql_result($result,$i,"ccyear");
$ccmonth = mysql_result($result,$i,"ccmonth");
$cczip = mysql_result($result,$i,"cczip");
$journal = mysql_result($result,$i,"journal");
$jam = mysql_result($result,$i,"jam");
$billingdata = mysql_result($result,$i,"billingdata");
$type1 = mysql_result($result,$i,"type1");
$type2 = mysql_result($result,$i,"type2");
$type3 = mysql_result($result,$i,"type3");
$type4 = mysql_result($result,$i,"type4");
$type5 = mysql_result($result,$i,"type5");
$type6 = mysql_result($result,$i,"type6");
?>
...............
Client
# .............................................................................................
Back
$i++;
ENDWHILE;
ENDIF;
?>
|