Page 2 of 2

Posted: Mon Nov 21, 2005 9:33 am
by Munky

Code: Select all

<?PHP
//error check
ini_set('display_errors', 1); 
error_reporting(E_ALL);

//list the fields coming from the form
$membername = $_POST['membername'];
$password = $_POST['password'];

//begin connection
include 'vars.php';

$link = mysql_connect('localhost', $user, $pass);
if (!$link) {
   die('Could not connect: ' . mysql_error());
}

mysql_select_db($database) or die(mysql-error()); 
$query="SELECT * FROM profileinfo WHERE membername LIKE '$membername' AND password = '$password'"; 
$result=mysql_query($query) or die (mysql_error());

// first test to make sure there was a result 
if (mysql_num_rows($result) == 1) { 
    echo "<b><center>Your Account</center></b><br><br>"; 

    // get the whole result of the query into an array 
    $row = mysql_fetch_assoc($result); 

    // set each individual variable 
    $membername   = $row['membername']; 
    $membernumber = $row['membernumber']; 
    $email        = $row['email']; 

    echo "<b>$membernumber</b><br><b>$email</b><br><a href='edit_account.php?membernumber=$membernumber'>edit</a><hr><br>"; 
} else { 
    // what gets displayed if there is no result found 
    echo '<b>Member details not found.</b>'; 


mysql_close($link);
?>
 
</body>
</html>
now i get a completely blank page as a result?

Posted: Mon Nov 21, 2005 9:39 am
by twigletmac
Need to add a closing brace after the else:

Code: Select all

} else {
    // what gets displayed if there is no result found
    echo '<b>Member details not found.</b>';
} // brace was missing here

mysql_close($link);
Mac

Posted: Mon Nov 21, 2005 9:42 am
by Munky
Thats got it... have a display now!!

WOO HOO thank you :)