sax0n
New Member
- Messages
- 11
- Reaction score
- 0
- Points
- 0
Right. I've been mulling this one around for a while and I have came up with this.
With the output...
Test
1
I dont get why level echos but name doesn't! :dunno:
Help is infinitley appreciated!
PHP:
<html>
<head>
<title> Main </title>
</head>
<body>
<h3> Test </h3>
<?php
$dbhost = 'localhost';
$dbuser = 'sax0n';
$dbpass = 'password';
mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql');
mysql_select_db("sax0n_main") or die;
$username = 'saxon';
$ui_query = mysql_query("SELECT * FROM user_info WHERE username = '$username' LIMIT 1");
$ui_table = mysql_fetch_assoc($ui_query);
echo $ui_table[level];
$co_long = $ui_table['co_ords_long'];
$map_query = mysql_query("SELECT * FROM map WHERE 'co_ords_long' = '$co_long' AND 'co_ords_lat' = '$co_lat' LIMIT 1");
$map_table = mysql_fetch_assoc($map_query);
$player_location = $map_table[name];
echo $map_table[name];
echo $player_location ;
</body>
</html>
With the output...
Test
1
I dont get why level echos but name doesn't! :dunno:
Help is infinitley appreciated!
Last edited: