Untitled

<?php
require('mysql.php');
session_start();
$username=$_SESSION['username'];

$user=mysql_query("SELECT * FROM users WHERE username='$username'") or die(mysql_error());

$username=$user['username'];
$level=$user['level'];
$race=$user['race'];
$class=$user['class'];
$hitpoints=$user['hitpoints'];
$hpmax=$user['hpmax'];
$manapoints=$user['manapoints'];
$mpmax=$user['mpmax'];
$heropoints=$user['heropoints'];
$experience=$user['exp'];
$expmax=$user['exp2nxt'];
$gold=$user['gold'];

$hp_percent=round($hitpoints/$hpmax)*100;
$mp_percent=round($manapoints/$mpmax)*100;
$exp_percent=round($experience/$expmax)*100;
?>

<div class="character">
<font size="6"><u><?php echo $username; ?> lvl <?php echo $level; ?></u></font><br><br>
<u>Race</u>: <?php echo $race; ?><br>
<u>Class</u>: <?php echo $class; ?></div><br>

<img src="charimages/hp_image.gif"> (<?php echo $hitpoints.'/'.$hpmax; ?>)
<div style="border:solid; border-width:thin; border-color:#000000; width:180px; height:12px;">
<img src="charimages/hp.GIF" width="<?php echo $hp_percent; ?>%" height="12" align="left">
</div><br>

<img src="charimages/mp_image.gif"> (<?php echo $manapoints.'/'.$mpmax; ?>)
<div style="border:solid; border-width:thin; border-color:#000000; width:180px; height:12px;">
<img src="charimages/mp.GIF" width="<?php echo $mp_percent; ?>%" height="12" align="left">
</div><br>

HeP (<?php echo $heropoints; ?>/100)
<div style="border:solid; border-width:thin; border-color:#000000; width:180px; height:12px;">
<img src="charimages/hep.GIF" width="<?php echo $heropoints; ?>%" height="12" align="left">
</div><br>

Exp (<?php echo $experience.'/'.$expmax; ?>)
<div style="border:solid; border-width:thin; border-color:#000000; width:180px; height:12px;">
<img src="charimages/exp.GIF" width="<?php echo $exp_percent; ?>%" height="12" align="left">
</div><br>

<img src="charimages/gold_image.gif"> <?php echo $gold; ?>