Getting data from database

[Ken2k7]

Say I have a database with a table named members with columns - id, member name, age etc..

 

Is there a way I can get the member name from the table members and store it in a variable $name without looping?

[phpSensei]

You Want To Get All The Member Names or Just one..??

[Ken2k7]

Just 1 please.

 

For example: I store the person's name into the database when they register but then I want to display that person's ID# when they log in. But I don't know how to pull just that one entry directly out of the database.

[hostfreak]

Straight from the manual (http://www.php.net/manual/en/function.mysql-fetch-assoc.php):

// While a row of data exists, put that row in $row as an associative array
// Note: If you're expecting just one row, no need to use a loop
// Note: If you put extract($row); inside the following loop, you'll
//       then create $userid, $fullname, and $userstatus
while ($row = mysql_fetch_assoc($result)) {
    echo $row["userid"];
    echo $row["fullname"];
    echo $row["userstatus"];
}

 

Look at comment line 2

[phpSensei]

Once They Log in Just use this code here

 

Login Page

<?php

session_start();

$_SESSION['user'] = $_POST['username'] // This Registeres That ONE username into a session called user, and $_POST is the username he entered from the form....//

?>

 

 

Index Page

 

<?php

session_start();

$username=$_SESSION['user'];

$query= mysql_query("SELECT * FROM username_table WHERE username = '$username'");

while($row=mysql_fetch_assoc($query)){

echo $row['username'];

}

?>

 

OR

 

<?php

$query= mysql_query("SELECT * FROM username_table WHERE id = 'The_Row_You_WANT'");

while($row=mysql_fetch_assoc($query)){

echo $row['username'];

}

?>