Getting info and echoing

[JayC]

Right I have been working on this page but its not getting the information I want from the database..

<?php
            $t = dbquery("SELECT * FROM users WHERE id = '".USER_ID."' LIMIT 1");
         
            echo '<img style="margin-top: -10px;" src="http://lunar-hotel.com/includes/imager.php?figure=' . $t['look'] . '&size=m">';
            ?>

So the variable T is getting the tables and then I want it to display the look of the character, but the problem is its not I am not sure why. I have tried multiple things but this is what it keeps looking like:

but if I removed ' . $t['look'] . ' and paste the actual code of my look it will work Anyone think they can help?

 

[Zaka]

Right I have been working on this page but its not getting the information I want from the database..

<?php
            $t = dbquery("SELECT * FROM users WHERE id = '".USER_ID."' LIMIT 1");
      
            echo '<img style="margin-top: -10px;" src="http://lunar-hotel.com/includes/imager.php?figure=' . $t['look'] . '&size=m">';
            ?>

So the variable T is getting the tables and then I want it to display the look of the character, but the problem is its not I am not sure why. I have tried multiple things but this is what it keeps looking like:

but if I removed ' . $t['look'] . ' and paste the actual code of my look it will work Anyone think they can help?

Yeah it should be mysql_query if you are writing the code with mysql_ syntax. Not dbquery. And the user id should be the variable holding the user id.

 

[Macemore]

<?php
mysql_connect("MYSQLSERVERHOSTHERE", "MYSQLUSERNAMEHERE", "MYSQLPASSWORDHERE", "MYSQLDATABASEHERE");
$t = mysql_query("SELECT * FROM users WHERE id = '".USER_ID."' LIMIT 1");

echo '<img style="margin-top: -10px;" src="http://lunar-hotel.com/includes/imager.php?figure=' . $t['look'] . '&size=m">';
?>

for mysql_connect you're gunna want the quotes

 

[JayC]

dbquery works too^ I do them both

I have global php it doesn't need to reconnect


Edit:
Now it is telling me Resource ID #

 

[Jerry]

Replace

SELECT * FROM users WHERE id = '".USER_ID."' LIMIT 1

With

SELECT * FROM users ORDER BY id DESC LIMIT 1

?

 

[Zaka]

The USER_ID needs to have a value.

 

[JayC]

yeah it needs to know which user to get the looks from

 

[GarettM]

yeah it needs to know which user to get the looks from

Id use $user['id'] its easier to read.

 

[Jerry]

Fixed it,

<?php

$getlook = mysql_query("SELECT * FROM users WHERE id = '".USER_ID."' LIMIT 1");
while($t = mysql_fetch_array($getlook)){
echo '<img src="/includes/imager.php?figure=' . $t['look'] . '&size=b&action=sit,wav,crr=667&direction=2&head_direction=3&gesture=sml&size=m" align="middle">';
}
?>

Proof:

 

[JayC]

Yup it works, thanks Jerry <3 You're the best

 

[Donkjam]

closed to reduce spam, well done on fix