|
/* declare some relevant variables */
$hostname = "mysql.whiz.to";
$username = "lodging";
$dbpassword = "lodging";
$userstable = "photos";
$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");
$queryb = "SELECT * FROM $userstable WHERE item='$p'";
$resultb = MYSQL_QUERY($queryb);
$numberb = MYSQL_NUMROWS($resultb);
$ib = 0;
IF ($numberb == 0) :
ELSEIF ($numberb > 0) :
WHILE ($ib < $numberb):
$item = mysql_result($resultb,$ib,"item");
$clientlink = mysql_result($resultb,$ib,"clientlink");
$ib++;
ENDWHILE; ENDIF;
$queryb = "SELECT * FROM client WHERE link='$clientlink' and email='$usernameb' and password='$passwordb' ";
$resultb = MYSQL_QUERY($queryb);
$numberb = MYSQL_NUMROWS($resultb);
$ib = 0;
IF ($numberb == 0) :
?>
Wrong Username or
password Back Information Saved Back |
|