please help .

[escalador]

Hello!

I have a page members.php . I want when someone logins on the page to show all his data.

Below i have the code, it's working but it shows everybody data...

How could i write the code , after login to see just your own data ?

$sql = 'SELECT userid, username, city
        FROM user
        WHERE username = username';

$result = mysql_query($sql);

if (!$result) {
    echo "Could not successfully run query ($sql) from DB: " . mysql_error();
    exit;
}

if (mysql_num_rows($result) == 0) {
    echo "No rows found !";
    exit;
}

while ($row = mysql_fetch_assoc($result)) {
    echo $row["userid"];
    echo $row["username"];
    echo $row["city"];
}

mysql_free_result($result);

this row

WHERE username = username';

could be something like this?

WHERE username = $_SESSION["username"]";

please help me

thank's

 

[ratcateme]

try this

$sql = 'SELECT userid, username, city
        FROM user
        WHERE username = "'.$_SESSION["username"].'";';

 

Scott.

[escalador]

oo thank you verry much !!!

i am looking this anser for 8 hours

and it's correct ! thank's a lot