Hi

trying to get my head round this problem.

ive got a login form working. once the users logged in it presents them with a form to be filled in. I want the users email and telephone to be automatically filled in from the data held in the mysql db. ive searched online and many books but cant find a solution for this.

Why not log the IP or use a cookie to refer the the user ID in the MySQL.

Though, it tends to not be a good idea to have stuff filled in for people, it helps hackers.

okay i never considered that. thanks alot for your help!

Heh, Books always give you an example way...not always the best way.

I found with the book I learn PHP from, I needed to work from it and try to do mini projects (for example, MySQL > Page and Array > Table) to really learn.

You always have to try these things out. PHP is more difficult in that respect - most other languages are more viewable. eg. view source etc. Books never quite tell you exactly what you want to know, I think.

this is a simple query to get the info

PHP Code:

$result = mysql_query("SELECT * FROM users WHERE id='$user_id'");
$row = mysql_fetch_array($result);
 
?>
<input type="text" value="<? echo $row['users_email'] ?>" name="email" />