• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Windows Problem with php sql query [Gesior]

Joined
Jul 18, 2014
Messages
193
Solutions
2
Reaction score
15
Hi!, i want to put in the character.php the currently player position; i already created the queries but when i call them appears nothing.
Here is what i did:
Code:
$posx = $SQL->query('SELECT posx FROM players WHERE name = '. $name .';');       
        $posy = $SQL->query('SELECT posy FROM players WHERE name = '. $name .';');
        $posz = $SQL->query('SELECT posz FROM players WHERE name = '. $name .';');

$main_content .= '<tr bgcolor="' . $bgcolor . '"><td>Position:</td><td>' . $posx . ' ' . $posy . ' ' . $posz . '</td></tr>';
$bgcolor = (($number_of_rows++ % 2 == 1) ?  $config['site']['darkborder'] : $config['site']['lightborder']);

The page loads good, but in Position field doesnt appear anything.
Please help.
Thanks.
PD: Im using Gesior for latest TFS.
 
Back
Top