php - How to display the data owned by a specific user? -

i working on following project :
user able add book database. thing trying achieve displaying image of book particular user has added on user profile. when user logs in able see images of of books added.

i have 2 tables called book & user field, id connected.

if (isset($_session['user_id'])) { $msg = "you logged in.<br/><a href='index.php'>home</a>"; $msg = "<a href ='logout.php'>logout</a>"; } else { //user not logged in //check whether form input 'username' contains value if (isset($_post['username'])) {     //retrieve form data     $entered_username = $_post['username'];     $entered_password = $_post['password'];     //connect database     include ("dbfunctions.php");     //match username , password entered database record     $query = "select *from role,user               user_name='$entered_username' ,                password = sha1('$entered_password') , user.role_id = role.role_id";     $result = mysqli_query($link, $query) or die(mysqli_error($link));     $query2 = "select * user,country user.country_id=country.country_id order `user`.`id` asc";     $result2 = mysqli_query($link, $query2) or die(mysqli_error($link));     $query3 = "select * user, book book.id = user.id ";     $result3 = mysqli_query($link, $query3) or die(mysqli_error($link));      if (mysqli_num_rows($result) == 1) {         $update = "update `user` set last_login = now() user_name='$entered_username' ";         $resultupdate = mysqli_query($link, $update);         $row = mysqli_fetch_array($result);         $_session['user_id'] = $row['id'];         $_session['username'] = $row['user_name'];         $_session['email'] = $row['email_address'];         $_session['gender'] = $row['gender_id'];         $_session['role_id'] = $row['role_type'];         $_session['lastlog'] = $row['last_login'];         $msg1 = $_session['username'];         $msg2 = "<b>gender: </b> " . $_session['gender'] . "<br/>";         $msg3 = "<b>email: </b>" . $_session['email'] . "<br/>";         $msg4 = "<b>your last visit on site: </b>" .  $_session['lastlog'];       } else { //record not found        echo "no record found";      } } }     if (mysqli_num_rows($result3) == 1) {     $rowz = mysqli_fetch_array($result3);    $_session['img'] = $rowz['image'];    $image= $_session['img'];      } else { //record not found         echo "no record found";      } ?> ...................................................................................... 

the html:

  <?php         } elseif ($_session['role_id'] == "member") {             ?>  <div class="panel panel-default">  <div class="panel-heading"><i>books</i> add</div>  <div class="panel-body"><?php echo $image;?></div></div>  } 

after doing this, when tried logging in every sample user, same image appeared though image added 1 user. how fix ?

check below code (from sample had given)

if (mysqli_num_rows($result3) == 1) {  }