[RESOLVED] fetching information from database

[fus10n]

okay, so I have information in a database that I want to fetch and echo. I need to figure out a way to fetch the info based on the username or ID and echo.

Table Example:

Id:1 Username:test Code:124
Id:2 Username:admin Code:1444

So Need a way to get code from user test.

[NogDog]

$user = "test";
$sql = "SELECT Code FROM Table_name WHERE Username='" . mysql_real_escape_string($test) . "'";
$result = mysql_query($sql) or die(mysql_error());
echo "<h3>User: " . $user . "</h3>\n";
while($row = mysql_fetch_assoc($result)) {
   echo "<p>Code: " . $row['Code'] . "</p>\n";
}

[fus10n]

Yes that works, but only for the user test. I need it to be dependent on who is logged in. I tried using sessions and declaring username as a variable from the login form but I kept getting an unexpected echo error.

[NogDog]

That's why I stuck in the $user = 'test' line, so you could replace that with however you want to specify the user to be queried (or just use a different variable in the query).

[fus10n]

Oh wow did not realize that would work. Thanks!