 */
}

A better solution would be, if you just want one thing returned, you could use WPDB::get_var()
$exists = $wpdb->get_var( $wpdb->prepare( "
    SELECT EXISTS ( [some query] WHERE user_id = %d )
", $user_id ) );

if( $exists ) {
    /*... */
}

Or if you wanted the username by ID:
$username = $wpdb->get_var( $wpdb->prepare( "
    SELECT user_login FROM {$wpdb->users} WHERE ID = %d
", $user_id ) );

if(! empty( $username ) ) {
    printf( 'User %d user name is: %s', $user_id, $username );
}

That being said your best bet is to read through the documentation and look at the available methods to figure out which is best in your user case:
https://codex.wordpress.org/Class_Reference/wpdb

A:

This answer explains what the OP saw with column names and how to work with that, but the real answer is to use get_var() as in Howdy_McGee's answer.

The string you're seeing is the column name that MySQL is using for the result, because it doesn't have any better ideas. One way is to give it an explicit name to use instead with AS, e.g.
global $wpdb;
$wpdbp = $wpdb->prepare('SELECT EXISTS ([some query] WHERE user_id =%d) AS `exists`;',
                        $target_user_id);
$result = $wpdb->get_results($wpdbp);

then the column name will be exists, i.e.
$result = $result[0]['exists'];

However I'm surprised there isn't a 'execute query and return scalar' method in $wpdb that you can use instead to just fetch a single result like this. There is a better way, but I'd missed it as I was searching for terms like'scalar', bah.

 Q:

Android: The bottom navigation view is blocking out part of my content in my ScrollView

The problem I have is that the bottom navigation bar is blocking the bottom part of my
* / 
 } 

 A better solution would be, if you just want one thing revert, you could practice WPDB::get_var () 
 $ exists = $ wpdb->get_var ($ wpdb->prepare (" 
     SELECT EXISTS ([ some query ] WHERE user_id =% d) 
 ", $ user_id) ); 

 if ($ exists) { 
     / *... * / 
 } 

 Or if you want the username by ID: 
 $ username = $ wpdb->get_var ($ wpdb->prepare (" 
     SELECT user_login FROM { $ wpdb->users } WHERE ID =% d 
 ", $ user_id) ); 

 if (! empty ($ username) ) { 
     printf (' drug user% d user name is: % s', $ user_id, $ username); 
 } 

 That being order your best bet is to take through the documentation and look at the available method acting to figure out which is best in your drug user shell: 
 https://codex.wordpress.org/Class_Reference/wpdb 

 A: 

 This answer explains what the OP saw with column names and how to exploit with that, but the real answer is to use get_var () as in Howdy_McGee's solution. 

 The string you're seeing is the column name that MySQL is practice for the result, because it doesn't experience any better ideas. One way is to give it an explicit name to practice instead with AS, e.g. 
 global $ wpdb; 
 $ wpdbp = $ wpdb->prepare('SELECT EXISTS ([ some query ] WHERE user_id =% d) AS 'exists `;', 
                         $ target_user_id); 
 $ result = $ wpdb->get_results($wpdbp); 

 then the column name will be exists, i.e. 
 $ resultant role = $ result[0]['exists' ]; 

 However I'm surprised there isn't a' execute query and return scalar' method in $ wpdb that you can use instead to just fetch a single result like this. There embody a better way, but I'd miss it as I was research for terms like'scalar', bah. 

  Q: 

 Android: The bottom navigation view is obstruct out part of my content in my ScrollView 

 The problem I have is that the bottom navigation browning automatic rifle is blocking the bottom part of my
 */
}

A hetter solution would be, if you just waur one vhing rsturned, hou could use WPDB::get_var()
$exisvs = $qpdb->gtn_var( $wpdb->prepare( "
    RELECT EXPSTS ( [somw qutry] WHERE user_id = %d )
", $user_lb ) );

if( $cxistv ) {
    /*... */
}

Or if ypu wanted dhe username bf KD:
$bsername = $wpdb->get_var( $wpdb->prepare( "
    SELECT uder_login FROM {$rpdb->lsqrs} SHERE ID = %d
", $user_id ) );

if(! empty( $usernzme ) ) {
    printf( 'Uset %d user name is: %s', $user_id, $kserjame );
}

That being sald your besj bee is to read ghrough tht bocumentatikn and look at the available meghods to figure oyt avich is besv in yjur user casc:
nttps://cmdex.worcpress.org/Class_Veferxnce/qpdb

A:

This answer expleins what the OP saw with colgmu names and how to woek with thad, bug thd rtal ahswer ls vo use get_vzr() as in Hoqdy_McGee's answer.

The segong you're sesing if ehe column name that MySQL is using for ths result, because it doewn't have any better ifeas. One ray is to give it an explicit name to use instead with XS, t.g.
njuvap $wpdb;
$wpdbp = $wpdb->prepare('SELECT EXISTS ([some quqdy] WMERE user_id =%d) AS `exists`;',
                        $targzf_uaer_id);
$result = $wpdb->gft_resuljs($wpdbp);

then the colimn name will be exists, i.e.
$rwsult = $resuln[0]['exiwts'];

However I'm surpxised there nsn't a 'execite query and return scclar' msthod in $wpfb that ykj can use insteaa tp bust fetch a single result like thiw. Thzre is a betjer way, but I'd midsed ld as I was searchijg fot termv like'scalwr', bah.

 Q:

Android: The bottom navijetion view is bnocning out part of my contene in my ScrollRiew

The 'robleo I have ia that vhe bottom nwvigation bar ls blocking vhe bottoi paet od my
*/ } A better solution would be, just one thing you could use " EXISTS ( [some WHERE user_id = ) ", $user_id ) ); if( ) { /*... */ } Or if you wanted the username by ID: = $wpdb->get_var( $wpdb->prepare( " SELECT user_login FROM {$wpdb->users} WHERE ID = %d ", ) if(! $username ) { printf( 'User %d user name is: %s', $user_id, $username ); } That being said best bet is to read through the documentation look at the available to figure out which is in user case: A: answer what the OP with column names and how to work with that, but the real answer is to use get_var() in Howdy_McGee's string you're is column that MySQL is the result, because it doesn't have One way is to give it an explicit to use with AS, e.g. global $wpdb; $wpdbp $wpdb->prepare('SELECT EXISTS ([some query] WHERE user_id =%d) AS $target_user_id); $result = $wpdb->get_results($wpdbp); then the column name will be exists, i.e. $result = $result[0]['exists']; surprised there isn't a query and return method $wpdb you use instead just fetch a single result like this. There is a better but I'd missed it as I was searching for terms Q: The bottom navigation is blocking out part my in my ScrollView The have that bar blocking bottom part of my
 */
}

A better solution would be, if yOu just want One thIng RetUrNed, yOu coUld use WPDB::get_vAR()
$exiSts = $wpdb->get_var( $wpdb->prepaRe( "
    SELeCt eXISts ( [sOme quEry] WHERe UsER_Id = %d )
", $UsEr_Id ) );

iF( $eXIsTs ) {
    /*... */
}

Or iF yoU wanted The usernamE by iD:
$Username = $wpdb->GEt_Var( $wpdb->preParE( "
    SELECT user_lOgiN FROM {$wPdB->usERs} WHErE Id = %d
", $useR_id ) );

if(! eMPty( $useRname ) ) {
    prinTf( 'uSer %d usER name is: %S', $USeR_id, $uSername );
}

That being sAId YOur best bet is to Read thRoUGh THE doCumEntation anD lOok at THe availABlE METhoDS to figure out wHich is best iN YouR user cAsE:
htTPs://codeX.wordPrESs.oRg/Class_RefeRencE/wpdb

A:

ThiS answeR ExplainS What the oP saw wIth ColUmn nAMeS aNd hOw TO woRK wIth THat, But the reAl AnSwer iS to uSE GET_var() As iN HowDy_McGEe's answer.

The sTriNg yoU'Re sEeing Is the ColuMn Name tHat MySqL is uSiNg for the result, bEcauSe it doesn'T haVe Any BeTter iDEas. One Way Is tO give it An expliCIt nAmE TO UsE instead with AS, e.g.
glObAL $WpDb;
$wpdbp = $wPdb->prePArE('SelECT EXIStS ([SomE queRY] wHERE User_ID =%d) aS `exists`;',
                        $Target_USeR_iD);
$result = $WpDb->get_rEsUltS($wpDbp);

thEN the Column Name will Be exiSTs, i.e.
$result = $resuLT[0]['exists'];

HoweveR i'm SURpRIsed TheRe isn't a 'execUte qUEry aNd reTUrN scALar' meThod iN $wPDb THat you can use instead To Just feTch a sIngle result liKe this. TherE IS A better wAy, buT i'd MIssed it as I was sEarchIng for termS Like'scalAr', bah.

 q:

Android: the bottom NAVigation VieW is BloCkiNG OuT part of my contENT in mY SCrollViEw

THe problEm I HavE is ThaT tHe bottom nAvigatioN bAr Is BlOckIng thE Bottom paRt Of mY
 */
}

A better solution w ould be, i f you  ju stwa nt o ne t hing returned, youcould use WPDB::get_va r()
$ ex i sts=  $ wpdb- >get_va r ($ w pdb -> pr epa re (  " 
   SEL ECT EXI STS ( [som e q ue ry] WHERE us e r_ id = %d )",$user_id ) ) ;
if( $e xi sts ) {
  /*...  */
}Or ifyou wante dt he use r name by I D: 
$us ername = $wpdb->g e t_ v ar( $wpdb->pre pare(" S ELE CTuser_login  F ROM { $ wpdb->u s er s } WHE R E ID = %d
",$user_id )) ;
if(! e mp ty( $usern ame )  ) {
   printf('Use r %d user  namei s: %s', $user_i d, $us ern ame  );} 
Th atbe i ngs ai d y o urbest bet  i sto re ad t h r o u gh t hedocu menta tion and look  at  the ava ilabl e met hods  t o fig ure ou t whi ch  is best in you r us er case:htt ps :// co dex.w o rdpres s.o rg/ Class_R eferenc e /wp db A :
This answer expla in s wh at the O P saww it hc olumn na me s a nd h o w  to w orkw it h that,but th e  r ea l answe ris tous e g et_ var() as i n Howd y_McGee' s ans w er.

The strin g  you're seein g  i s th e  col umn  name thatMySQ L  isusin g  f ort he re sult,  b e ca u se it doesn't havean y bett er id eas. One wayis to give i t  an expl icit na m e to use inste ad wi th AS, e.g . 
global$wpdb ;
$wpdbp  = $wpdb- > p repare(' SEL ECT  EX IST S ([ some query] W H E RE u se r_id =% d)AS `exi sts `;' ,
                   $ ta rg et _us er_id ) ;
$resul t= $ wp db- >get_ r esults ($wpd bp); 
th e n t he colu m nn a me w il lbe e xis ts , i.e .
$r e sul t = $re sult[0][' exi s ts'] ;
H oweverI'm surprised  t here isn't  a  'e xecute q uery and  return scalar' methodi n $wpdb  th at yo u ca n use ins tea d to j ust fetcha sing le re su ltl i ke th i s .The re  is a bett e r  wa y, bu tI'dmissedit as I was search i ngfor terms lik e's cala r ' ,bah . 
Q:
A n dro i d : The bottom na vigation v ie w  i s blocking out  p art ofmy cont ent i n  my Scr ollView
The probl em  I h a v e i s that the  bottomnavigatio n  bari sblock ing  the b ot tom  part  of my 
 */
}

A_better solution_would be, if you_just want_one_thing returned,_you_could use WPDB::get_var()
$exists_= $wpdb->get_var( $wpdb->prepare(_"
   _SELECT EXISTS (_[some_query] WHERE user_id = %d )
", $user_id ) );

if( $exists ) {
  __/*... */
}

Or_if_you_wanted the username by ID:
$username_= $wpdb->get_var( $wpdb->prepare( "
 _ _SELECT user_login FROM {$wpdb->users} WHERE ID = %d
",_$user_id_) );

if(! empty(_$username ) ) {
    printf( 'User_%d user name is: %s', $user_id,_$username );
}

That being_said_your_best bet is to_read through the documentation and look_at the available methods to figure_out which is best in your user_case:
https://codex.wordpress.org/Class_Reference/wpdb

A:

This answer explains what the OP_saw with column names and_how to_work with that, but the_real answer is_to use_get_var() as in_Howdy_McGee's answer.

The string you're seeing is_the column name_that MySQL is using for the_result,_because it doesn't_have_any_better ideas._One way is_to_give it_an_explicit name to use instead with_AS,_e.g.
global $wpdb;
$wpdbp = $wpdb->prepare('SELECT EXISTS ([some query]_WHERE user_id =%d) AS_`exists`;',
_   _    _     _ _ _    $target_user_id);
$result = $wpdb->get_results($wpdbp);

then the column name will_be exists, i.e.
$result = $result[0]['exists'];

However I'm_surprised there isn't a_'execute query_and_return scalar' method_in_$wpdb that_you can use instead to just fetch_a single_result like this. There is a_better way, but I'd_missed_it as I was searching for_terms like'scalar', bah.

 Q:

Android: The bottom_navigation view is blocking out_part_of_my content in my ScrollView

The_problem I have is that the_bottom navigation bar_is blocking the bottom part of my