SQL Glitch

[xyn]

Hi Guys,
Right I have got one minor problem nothing to big or hard but
I just don't understand what I'm doing wrong. On my Login page
I set two sessions:
1. being $_SESION['LoggedIn'] = true;
and 2. being $_SESSION['username'] = $user; ($user being the user field)

Well When i include my Sessions code ie checking if the session
LoggedIn is true, I also have the Username Session. When I use:
[code=php:0]echo $username;[/code] or [code=php:0]echo $_SESSION['username'];[/code]

It outputs:
[b]Array[/b]
???

[zq29]

How are you setting the variables? Somehow you are creating them as arrays. You can view the structure of your arrays with something like...
[code]<?php
echo "<pre>";
print_r($array);
echo "</pre>";
?>[/code]

[xyn]

it's confusing because I didn't create an array...

[wildteen88]

How is $user being created? Are doing something like thios:
[code=php:0]$user = mysql_fetch_array[/code] or [code=php:0]$user = mysql_fetch_row[/code]

If you did then mysql_fetch_array and mysql_fetch_row will store the result in an array within the $user variable.

If you want to just store the username then do this:
[code=php:0]$user = mysql_fetch_array($result);
$_SESSION['username'] = $user['username'];
$_SESSION['password'] = $user['password'];[/code]