<?php
include("header.php");
include("rmb.php");
$cxn = mysqli_connect($host,$user,$passmilah,$dbase)
    or die("Couldn't connect to server");

$sql = "SELECT * FROM user WHERE email = '$_GET[id]'";
$result = mysqli_query($cxn,$sql)
    or die(mysqli_error($cxn));
while($row = mysqli_fetch_array($result))
{
    echo "email: " . $row['email'];
    echo "<br/>";
    echo "name: " . $row['name'];
    echo "<br/>";
    echo "adress: " . $row['adress'];
    echo "<br/>";
    echo "amount of listings: " . $row['listings'];
}

echo "</br>";
echo "<form action = 'edit_profile.php?id=" . $_SESSION['logname'] . "'>
<input type = 'submit' value = 'Edit Profile' />
</form>";
?>