im making a file host site but i want a auto update earn

[andy1090]

$connet = mysql_connect("host", "db_username", "pass") or die(mysql_error());

$user = $_SESSION['SESS_FIRST_NAME'];
mysql_select_db('db_name, $connet) or die(mysql_error());

mysql_query("SELECT members Get $earn='earned' WHERE $user='username' LIMIT 1;");
$earn = $total_earn;
?>
<a>$<?php echo "$total_earn";?></a>

 

 

 

[Pikachu2000]

And what seems to be the problem?

[andy1090]

well i want to get earned from the mysql  and post it but i dont know how to get it to run