What am I doing wrong on PDO?

[Proximity]

<?php
$getlooks = pdoengine::connect()->prepare("SELECT * FROM users WHERE id = '".$_SESSION['user']['id']."'");
$getlooks->execute();
$data = $getlooks->fetchAll();
foreach ($stats as $data) {
}
?>

on head and then this is what I am trying to pull

<?php echo $stats['id']; ?>

 

[Genaga]

Whats happening? Are you getting an error? What does it say? It the PDO definitely connected?

 

[Proximity]

It should work but it isn't
 
@Sledmore help pelase

 

[Genaga]

Where is $stats declared and set? I can't see it anywhere

 

[Proximity]

<?php$getlooks = pdoengine::connect()->prepare("SELECT * FROM users WHERE id = '".$_SESSION['user']['id']."'");
$getlooks->execute();
$data1 = $getlooks->fetchAll();
foreach ($stats as $data1) {
//echo $row['whatever row you want']

?>
<div class="c-title orange">%user_name% Stats!</div>
<div class="c-main me">
<div style="align:left;">
<div align="left">
<div><img src="%www%/images/icon_habbo_small.png"> User ID: <b><?php echo $stats['id']; ?></b></div>
<div><img src="%www%/images/credits.png"> Credits: <b><?php echo $stats['credits']; ?></b></div>
<div><img src="%www%/images/duckets.png"> Duckets: <b><?php echo $stats['activity_points']; ?></b></div>
<div><img src="%www%/images/diamond.png"> Diamonds: <b><?php echo $stats['diamonds']; ?></b></div>
<div><img src="%www%/images/owner_icon.gif"> ROTW Points: <b><?php echo $stats['ROTW_Points']; ?></b></div>
<div><img src="%www%/images/terms_icon.gif"> Rank: <b><?php echo $stats['rank']; ?></b></div>
<div><img src="%www%/images/crown.png"> Respects Received: <b><?php echo $statss['respects']; ?></b></div>
<?php
}
?>
One thing I am trying to do....

But that didn't work....

 

[Genaga]

foreach ($data1 as $stats) try that, I think you have it the wrong way round.

Also do
<pre>
<?php print_r($data1);?>
</pre>
to make sure you're getting the data properly.

 

[Proximity]

I fixed it site something wrong please close thread

 

[Thursday]

When learning, it is very handy to have a

You must be registered for see links

account as the members within their site are extremely helpful with any issues you are having.