Hi, I want to display the 'name' field from mysql database 'user' on my webpage once the user logs in.

There could be 2 people with the same login details but with different names so I would like it to display both names in 2 columns if possible.

so far I have:

$sql = "SELECT name users WHERE username = '" . $_SESSION['username'] . "'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
echo "Hello, " . $row['name'] . ").";