call only one user

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


header ( “Location:login.html”);

<?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
Senior Mentor
Junior Mentor
<?php } ?>

MOD EDIT: Added code tags

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

Sponsor our Newsletter | Privacy Policy | Terms of Service