session help with if statement

[jasondavis]

I have this code

<?
$feasql="select featured from friend_reg_user where auto_id='$info[auto_id]' and featured='yes'";
$fears=getsingleresult($feasql);
if($fears=='yes')
{
if it is yes save it to a session with the value of yes here

}
?>

This code is getting loaded every page load and what I would like to do is get this information into a session variable so I can load it 1 time (ie in my login section) any help would be great im a newbie

[devinemke]

$feasql = "select featured from friend_reg_user where auto_id = '" . $info['auto_id'] . "' and featured = 'yes'";
$fears = getsingleresult($feasql); 
if ($fears == 'yes')
{ 
	session_start();
	$_SESSION['featured'] = 'yes'; 
}