$sql=mysql_query("SELECT field1 FROM Tabla "); while($usermic=mysql_fetch_array($sql)) { echo "<h4><a href='/perfil/{$usermic['nick']}</h4>"; }