php - Session ID error -

php - Session ID error -

error: have error in sql syntax; check manual corresponds mysql server version right syntax utilize near '' @ line 1 - this error.

all trying create simple show current logged in user wont work me here code:

<?php //get session id $session = isset($_session["user_id"]); // sql statement database username $query = "select * tbl_sys_user usr_id = ".$session.""; $result = mysqli_query($db,$query) or die("error: ".mysqli_error($db));; while($row = mysqli_fetch_array($result)) { echo "<p class='white'>".$row['usr_name']."</p>"; } ?>

try changing this:

$query = "select * tbl_sys_user usr_id = ".$session."";

to this:

$query = "select * tbl_sys_user usr_id = '".$session."'";

php html