Posted: Mon Nov 21, 2005 9:33 am
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>