Mostrar conteúdo oculto

Fatal error: Cannot use object of type PDOStatement as array in C:\xampp\htdocs\layouts\tibiarl\arquivo.php on line 4

deu esse erro

e o castleowner atualiza na database

 

Se for esse arquivo aqui, tenta assim

 

Mostrar conteúdo oculto

<div class="sidebar">
<?php
$guild = $SQL->query('SELECT `name` FROM `guilds` WHERE `castleowner`=1;');

?>
<style type="text/css" media="all">
   .name {
    position: relative;
    top:40px;
    text-align: center;
    font-family: Tahoma, Geneva, sans-serif;
    font-size: 9.2pt;
    color: #FFF;
    font-weight: bold;
   }
   .logo {
    position: relative;
    top: 50px;
    text-align: center;
   }
  .CastleWarbox {
    position: relative;
    margin-top: 10px;
    margin-bottom: 5px;
    width: 200px;
    height: 200px;
  }
</style>
    <div id="CastleWar" class="CastleWarbox" style="background-image:url(https://i.imgur.com/ASZv7fN.png);">
         <?php
        if ($guild) {
        ?>
            <div class="logo">
                 <img style="max-height:100px;" src="<?php logo_exists($guild); ?>">
            </div>
            <div class = "name">
                <?php echo '<br><a href="guilds.php?name='.$guild.'">'.$guild.'</a><br>';?>
            </div>
                        
        <?php
        }else ?>
        <div class = "name">
                <?php echo '<br><br><br><p>No Have Owner</p><br>';?>
        </div>
   </div>
</div>

 

 

  Em 22/10/2017 em 07:59, felipecsx disse:

@psychonaut 

O script executou certinho na database só que na parte php ele não está lendo... fica assim

 

deu certo, mais ficou igual a ele, sem nada =/ 

Tentou com a classe?

 

Mostrar conteúdo oculto

<div class="sidebar">
<?php
$guild_id = $SQL->query('SELECT `id` FROM `guilds` WHERE `castleowner`=1;');
$guild = new Guild();
$guild->load($guild_id);


?>
<style type="text/css" media="all">
   .name {
    position: relative;
    top:40px;
    text-align: center;
    font-family: Tahoma, Geneva, sans-serif;
    font-size: 9.2pt;
    color: #FFF;
    font-weight: bold;
   }
   .logo {
    position: relative;
    top: 50px;
    text-align: center;
   }
  .CastleWarbox {
    position: relative;
    margin-top: 10px;
    margin-bottom: 5px;
    width: 200px;
    height: 200px;
  }
</style>
    <div id="CastleWar" class="CastleWarbox" style="background-image:url(https://i.imgur.com/ASZv7fN.png);">
         <?php
        if($guild->isLoaded())
		{
		$guildname = htmlspecialchars($guild->getName());
        ?>
            <div class="logo">
                 <img style="max-height:100px;" src="<?php echo $guild->getGuildLogoLink(); ?>">
            </div>
            <div class = "name">
                <?php echo '<br><a href="guilds.php?name='.$guildname.'">'.$guildname.'</a><br>';?>
            </div>
                        
        <?php
        }else ?>
        <div class = "name">
                <?php echo '<br><br><br><p>No Have Owner</p><br>';?>
        </div>
   </div>
</div>

 

 

tentei, ficou dá mesmo forma, aparece e tal , mais não mostra a guild