Posted by Dave Nash on 12/14/06 02:21

I have a login form setup. When a person logs in it verified the user
name and password and logs them in if the information is correct.
This script is called auth.php as in included in all of the pages I
want to secure.
My problem is how do I get info on that particular logged in user…
example say Welcome $fullname when the only two fields ive currently
go are u_name and p_word.
See auth script below.

And

How to get info from another table?

Example SELECT * FROM messages WHERE userid = $userid ORDER by
messageid

-------------------------------
Auth.php

session_start();
if($_POST){
$_SESSION['u_name']=$_POST["u_name"];
$_SESSION['p_word']=$_POST["p_word"];
}
$result=mysql_query("select * from users
where u_name='" . $_SESSION['u_name'] . "' and p_word='" .
$_SESSION['p_word'] . "'");
$num=mysql_num_rows($result);
if($num < 1){
echo "show login form";
exit;
}
End auth.php
-------------------------------
Tables are as follows.
Users table.
userid
u_name
p_word
fullname
PRIMARY KEY (`userid`)

[Back to original message]