call only one user

[beylah]

thanks for all those that help - i am able to call the data but now i only want to call one row from the table - the row of the user that logged in - here is my code

[code]<?php

/*if(!$auth==“ok”)
{
header ( “Location:login.html”);
exit;
}
*/
$id==“id”;
?>

<?php include("config.php"); $connection=mysql_connect($hostname,$username,$password) or die ("Failed to connect."); mysql_select_db($dbname,$connection) or die ("Cannot connect to DB"); $result=mysql_query("SELECT * FROM team") or die ("Could not execute query."); ?> T.E.A.M.

<?php while($rows=mysql_fetch_array($result)){ ?>

Welcome <?php echo $rows['FIRST_NM']; ?>

Bank Account:

<? echo $rows['BANK']; ?>

View Profiles

<?php echo $rows['FIRST_NM']; ?>'s Profile

Senior Mentor Profile

Junior Mentor Profile

<?php } ?>

[/code]

MOD EDIT: Added code tags

[Zyppora]

Check out the WHERE clause for SQL queries. That should get you going.