Modifying a script to store information into a table rather then a cookie

[ghurty]

Currently I am using the following script to store cookies

if(isset($_GET['activelocation'])){
$activelocation = $_GET['activelocation'];
setcookie('location', $activelocation, time()+60*60*24*30);
} elseif(isset($_COOKIE['location'])){
$activelocation = $_COOKIE['location']; //if the cookie is set, get the value
} else{
setcookie('location', 'New York, NY', time()+60*60*24*30);
$activelocation = "New York, NY";
}

 

But I realized that being I anyway have registered users on the my site, it would probably be better of storing it in their account preferences.

How would I go about modify this so that instead of creating a cookie it stores it into a field in my user table?

Also, I would want it that if the user is not logged in, then it will use cookies, but first it should look to see if person is logged in, and rather use that

 

Thanks

[NArc0t1c]

UPDATE users_table SET activelocation='$activelocation' WHERE loggedin=1 AND user_identity='$identity'

That's a mysql query, that you could use.

[ghurty]

Thank you,

But what string do I use to pull in the data back?

[uwannadonkey]

Select would take out the items from your mysql, and you use mysql_fetch_assoc or fetch object to echo it

 

 

(if im not mistaken!)

 

an example:

 

$usersql = @mysql_query("SELECT * FROM users WHERE ID = '$uID'");

$user = @mysql_fetch_object($usersql);

 

now, all colums in your database are stored with the variable $user

 

to echo a column, you would type echo "$user->(columnname)";