[SOLVED] problem with links

[gli]

<?php require_once("databasec.php"); ?>
<?php

$query = "SELECT * FROM users"; 

$result = mysql_query($query) or die(mysql_error());


while($row = mysql_fetch_array($result)){
echo $row['username']. " - ". $row['country'];
echo "<br />";
}
?>

 

hi! i need to make link for $row['username'] but link like profile.php?user=$row['username']

[rhodesa]

<?php require_once("databasec.php"); ?>
<?php

$query = "SELECT * FROM users"; 

$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){
echo "<a href='profile.php?user={$row['username']}'>{$row['username']}</a> - {$row['country']}<br />";
}
?>

[gli]

thnx