Hola, no se nada de mysql así que :D trato de aprender.
Con esta sintaxis me conecto a la BD y saco algunos datos
Código PHP:
Ver original<?
if (isset($_POST["profile"])) {
require("includes/character.class.php");
option::profile($_SESSION['user']);
} require("config.php");
$account_id = clean_var($account_id);
$check = $db->Execute("Select country,gender,age,y,msn,aim,icq,skype,avatar,hide_profile from MEMB_INFO where memb___id=?",array($account_id)); $slect_profile2=$check->fetchrow();
if($slect_profile2[8] == NULL){ $insert=$db->Execute("Update MEMB_INFO set hide_profile='0' where memb___id=?",array($account_id)); }
$select_profile_sql=$db->Execute("Select country,gender,age,y,msn,aim,icq,skype,avatar,hide_profile from MEMB_INFO where memb___id=?",array($account_id)); $slect_profile=$select_profile_sql->fetchrow();
if($slect_profile[9] == '0'){$slect_profile[9] = "<option value='0'>No</option><option value='1'>Si</option>"; }
elseif($slect_profile[9] == '1'){$slect_profile[9] = "<option value='1'>Si</option><option value='0'>No</option>"; }
?>
y quiero mostrar <? echo($slect_profile[6]); ?>, el problema es que solo me muestra si estoy logeado, como lo hago para mostrar el contenido de $slect_profile[6]

x cierto cada usuario tiene su id.