dark dude Posted June 10, 2006 Share Posted June 10, 2006 Ok, I know how to assign sessions, you get the information from the Form and assign it to the Session like:$_POST['Username'] = $Username$Username = $_SESSION['Username']What I wanna know is how you take data from the database where the Session Username == The database username, and assign that to a session, if you get what I mean. Link to comment https://forums.phpfreaks.com/topic/11658-assigning-sessions-through-mysql/ Share on other sites More sharing options...
poirot Posted June 10, 2006 Share Posted June 10, 2006 Your code is a bit odd... Don't you mean:$_SESSION['Username'] = $_POST['Username']?Anyway, if you want to retrieve data from the db, do as you would usually, but now with a variable. Like:[code]$user = $_SESSION['Username'];$query = "SELECT * FROM `users` WHERE username='$user'";$result = mysql_query($query) or die(mysql_error());[/code] Link to comment https://forums.phpfreaks.com/topic/11658-assigning-sessions-through-mysql/#findComment-44025 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.