$que = mysql_query("SELECT `analyst_id` FROM `Analysts` WHERE username = '$username'"); while($row1 = mysql_fetch_assoc($que)){ $analyst_id = $row1['analyst_id']; } echo $analyst_id; $sql = mysql_query("SELECT ipaddy, login, logout, os, ib FROM Sessions WHERE analyst_id = '$analyst_id'"); while($row = mysql_fetch_assoc($que)){ $ipaddy = $row['ipaddy']; $login = $row['login']; $logout = $row['logout']; $os = $row['os']; $ib = $row['ib']; } echo "
| IP Address | Login Time | Logout Time | Operating System | Internet Browser | |
|---|---|---|---|---|---|
| $ipaddy | $login | $logout | $os | $ib |