[djburnage]

Hi
I have a simple login script. At the moment it stores the cookies with just the username and password that the user specified But i would like it to also store the group that the user is in, in the cookie. The group is specified along side the username and password collom in a mysql table called "login". So im guessing i would need some sort of mysql query.
I was wondering if anyone can tell me how to do this.
The bit bellow is only part of the script

PHP Code:

$username = $_POST['username'];

$password = $_POST['password'];

if ($username=="") {

die("You must enter a username!");}

if ($password=="") {

die("You must enter a password!");}

$query = "SELECT * FROM login WHERE username ='$username'";

$result = mysql_query($query) or die('Query failed: ' . mysql_error());

$data = mysql_fetch_array($result, MYSQL_ASSOC);

$truepass = $data['password'];

if ($truepass == $password) {

$cookie = $username;

setcookie("user",$cookie);

setcookie("pass",$truepass); 

thanks
chris

[UnrealEd]

as you allready use a query that will select all data from the login table, you just have to select the "group" value in the $data array:

PHP Code:

$group = $data["group"];

setcookie("group", $group); 

UnrealEd

[grafman]

Also,

You might want to consider using $_SESSION rather than cookies. $_SESSION sets a single cookie on the client side with a session id, but you can store anything you want (well mostly) in it just as though it were a persistent associative array.

All you have to do is put session_start() at the top of any program you want to access the data.

[djburnage]

Thanks for your help