Php update

[Anonymous]

Здравейте искам да направя чрез клик да се добавя 20 пари и да се маха 5 енергия?Мерси!

 

[macmen]

дай си имената на на Полетата

 

[Anonymous]

1-energiq
2-money
Ай ако може да ми помогнеш с един код виш
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("test", $con);



$result = mysql_query("SELECT * FROM members WHERE username = '$username'");

while($row = mysql_fetch_array($result))
{

?>



<table width="300" border="0" align="left" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<form name="form1" method="post" action="checklogin.php">
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td colspan="3"><strong>Potrebitelski panel </strong></td>
</tr>
<tr>
<td width="78">Username</td>
<td width="6">:</td>
<td width="294"><?php echo $row['username'];?></td>
</tr>
<tr>
<td>Pari</td>
<td>:</td>
<td><?php echo $row['money'];?></td>
</tr>
<tr>

<tr>
<td>Krediti</td>
<td>:</td>
<td><?php echo $row['credits'];?></td>
</tr>
<tr>
<td>Energiq</td>
<td>:</td>
<td><?php echo $row['energiq'];?></td>
</tr>
</tr>
</table>
</td>
</form>
</tr>
</table>
<a href='logout.php'>Izhod</a>
<?php
}



?>
Искам при вход да ме логва като ми избира чрез ид като select from where id='$id

 

[macmen]

<?php
if (isset ($_POST['UPDATE'])){
$query = "SELET money,energiq FROM TBL WHERE po koeto go opedelq6 tam ";
$rs = mysql_fetch_assoc(mysql_query($query));
$money = $rs['money'] + 20;
$energiq = $rs['energiq'] - 5;
$q = "UPDATE TBL SET money='$money', SET energiq = '$energiq' WHERE po koeto go opedelq6 tam " ;
mysql_query($q);
}
?>

<form action="" method="POST">
<input type="hidden" name="UPDATE" value="1"/>
<input type="submit" name="submit" value="Обнови"/>
</form>

нещо такова трябва да е