User specific query

[johnnyblaze9]

Can someone tell me how to generate user specific querys?  What I mean is:  When John Doe logs in I would like the next page to display information from my database specific to only him...and so on for other clients.

[DarkWater]

If you use sessions for your login system, it's really easy.  Store the user_id of the user in a session variable, and do something like this:

<?php
$query = "SELECT * FROM users WHERE user='{$_SESSION['user_id']}'";
$result = mysql_query($query);
$user_data = mysql_fetch_assoc($result);

//Then do stuff with the data, like echo "Hello, " . $user_data['username'] . "!";
?>