3 replies to this topic

[Friiks]

Well basicly problem is that I have always used while loop to get data from database and I don't know how to get only one result which should be the users id.
I did it with while loop like this

	
$result = mysql_query("select * from users");
while($r=mysql_fetch_array($result))
{
$id=$r["id"];
$_SESSION['id'] = $id;}
  $_SESSION['username'] = $username;
		$_SESSION['user_level'] = $user_level;

It registers the id in a session and the query selects a table called 'users'...but all the users get the same id number displayed now...
If this doesn't explain all I can send the full code in a pm as I don't want to post it here...

[Mr. Matt]

simple:

$result = mysql_query("select * from users");
$r=mysql_fetch_array($result);

$id=$r["id"];
$_SESSION['id'] = $id;}
$_SESSION['username'] = $username;
$_SESSION['user_level'] = $user_level;

Matt

[dotbart]

Mr. Matt, on Nov 19 2006, 05:23 PM, said:

simple:

$result = mysql_query("select * from users");
$r=mysql_fetch_array($result);

$id=$r["id"];
$_SESSION['id'] = $id;}
$_SESSION['username'] = $username;
$_SESSION['user_level'] = $user_level;

Matt

Remember to delete the }

So it's:

$result = mysql_query("select * from users");
$r=mysql_fetch_array($result);

$id=$r["id"];
$_SESSION['id'] = $id;
$_SESSION['username'] = $username;
$_SESSION['user_level'] = $user_level;

[Mr. Matt]

already helped him fix this.

Matt