Yes, you basically answered your own question. However, there's a slight complication. While you were on the right track, your logical solution for what you use in your WHERE clause could be problematic, since you use username. Now, you did specify "same" user. But! What do you do when different people have the same name? Then you'll have problems. The best would be to have a user id to go by. That will be unique and ensure that you will retreive data from that user only.
//You'll have to implement a userId field in your table(s)
SELECT * FROM tracking_table WHERE userId='1';
Since you added PHP to your tags, I'm wondering if you need to use it in PHP later?
In that case, depending on your syntax (mysql_ / mysqli_ / PDO) you can store them into PHP variables for later use.
mysql_ syntax:
<?php
//Note that mysql_ is deprecated. I simply just included this in case.
//Select statement
$sql="SELECT * FROM tracking_table WHERE userId='1'";
//Result set from your select
$result=mysql_query($sql);
//The rows of data
$row=mysql_fetch_array($result);
//Row data stored as variables
$id=$row['Id'];
$username=$row['Username'];
$log=$row['Log'];
$lan=$row['Lan'];
$timestamp=$row['Timestamp'];
?>
mysqli_ syntax:
<?php
/*
$conn is the database connection variable from you config.php
(assuming that's the name of the include file for your database connection)
*/
//Select statement
$sql="SELECT * FROM tracking_table WHERE userId='1'";
//Result set from your select
$result=mysqli_query($conn, $sql);
//The rows of data
$row=mysql_fetch_array($conn, $result);
//Row data stored as variables
$id=$row['Id'];
$username=$row['Username'];
$log=$row['Log'];
$lan=$row['Lan'];
$timestamp=$row['Timestamp'];
?>
