unable to create login personal data system

THE LOGIN CODE
[php]<?php
session_start();

//connect database
require_once(“db_connect.php”);
$db=mysqli_connect($host,$user,$password,$db);
mysqli_select_db($visa,“job”)or die(mysqli_error($visa));

//username and password sent from the form
$username=$_POST[‘username’];
$password=$_POST[‘password’];

//to protect mysqli injection
$username=mysqli_real_escape_string($username);
$password=mysqli_real_escape_string($password);

$qry=“SELECT * FROM member WHERE username =’$username’ and password = ‘$password’”;
$result=mysqli_query($db,$qry) or die(mysqli_error());
//$row=mysqli_fetch_array($result);

//mysqli_num_row for counting rows
$count=mysqli_num_rows($result);
//if result match username and password
if($count==1){
//register username and password
$_SESSION[‘username’] = $_POST[‘username’];
$_SESSION[‘password’] = $_POST[‘password’];
header(“location:member_page.php”);
} else {
echo"wrong username and password";
}
?>[/php]

PERSONAL PAGE CODE
[php]<?php
session_start();
require_once(“db_connect.php”);
//require_once(“auth.php”);

$sel= “SELECT username, name, occupation, sex ,phone ,email FROM member WHERE username = ‘$_SESSION[username]’”;
$result = mysqli_query($sel) or die(mysqli_error());
?>

YOUR PERSONAL INFORMATION

<?php $row = mysqli_fetch_assoc($result); echo''; echo''; echo''; echo''; echo''; echo''; echo''; echo''; ?>

[/php]

ID USERNAME NAME SEX OCCUPATION EMAIL
'.id.''.username.''.name.''.sex.''.occupation.''.email.'

which part is giving the errors?

Sponsor our Newsletter | Privacy Policy | Terms of Service