Can't get info from Mysql Database

[monkeybidz]

Can't get the information from my_private. What do i need to use at my_private to get the info from database to make the bottom function or action work?

 

Possible Values in my_private are:'Yes' or 'No'.

 

$sql_private="SELECT * FROM my_members WHERE my_id='$myid' AND my_private='--This is what i need to get--' ";

$my_private=$sql_private['my_private'];

 

if($my_private=='Yes'){

  header("Location: gen_confirm.php?errmsg=".urlencode("This user has profile set to private. Only friends can view this page.<BR><a href=".addme_request.php.">Click here to request to be added.</a>"));

die();

}

 

Thanks in advance!

Man, i hate being a newbie!

[cooldude832]

first off you ain't connecting to a database, secondly you ain't querying

read up basic mysql tutorials and you will see your issue.  $sql_private is a string and nothing more in your case