Getting values from table and storing it to variable.. PHP & MySQL

[deepode]

I have one table which contains user_id, username, password and points columns. It is in table named "users" in database named 'admin_users".

When one successfully login, the following is set...

$username = $_SESSION['username']; 

now, i want to store $points variable equal to points of user named "$username" , how to do it. Means (i think i wasn't clear what i wanted to say), i want to get value of column "points" from table users where username = $username....

I am totally confused, hope you help.

[NoEffinWay]

Something like this:

$query = "SELECT * FROM table WHERE username = 'someuser'";
$exe = mysql_query($query);
while($row = mysql_fetch_array($exe)){
foreach($row as $r => $v){
/* $r is the column name and $v is the value */
$_SESSION[$r] = $v;
}
} 

[deepode]

P.S. : COULD ANYONE BELIEVE THIS? I ANSWERED TO MY OWN QUESTION..........

Thanks it worked....

Well i now have another task, I want to update those points how to it?

I just want to know how to update that table and get value back?