showing the table of current user

[mage1]

How can I show the table of the current user? Because when I log out and I try to login with a different account  then I go to showtables.php, It always shows the table of the last inserted information and not the table of the current user.

 

Heres my code:

 

<?php

mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("<database name>") or die(mysql_error());


$result = mysql_query("SELECT * FROM regusers")
or die(mysql_error());  


$row = mysql_fetch_array( $result );

echo " Password: ".$row['password'];
echo " Email: ".$row['email'];
echo "Nickname: ".$row['nickname'];

?>

[budimir]

Well you need something like ...

 

$result = mysql_query("SELECT * FROM regusers WHERE user_id='$id'")

 

But of course, your user needs to log in , otherwise you won't be able to know which users info to display.

[mage1]

thank you so much sir!