Artsybetty

cheers barand.

whats the best way to set session variables from db? i'm kinda new to this, so im just checking the session variable "uid" against the users id in the db, and if true, posting something, should i be doing this totally different? any help is apreciated $result = mysql_query("SELECT * FROM `users` WHERE `id`='".$_SESSION["uid"]."' LIMIT 1"); while($row = mysql_fetch_array($result)) { echo $row['username']; echo $row['id']; }

excuse my VERY short hand in the previous post, ^^ thats exactly what i was looking for. thankyou both for the input!

so, as my uid contains no letters, if isset( (int) $_SESSION['uid'] === 0 ){ not logged content} else {logged in content} should work? and i'm presuming that (based on your post) checking for non logged users first is the best route?

this will be used to check for a valid user id to show certain pages to logged in users, does it make a difference (beside the obvious order after the statements) and if so what method is more secure? any suggestions are appreciated