Sql +1

[Acceptu]

Is there any reason why tis should not work?

mysql_connect("localhost", "db", "pass");
mysql_select_db("xtremega_new");
$result = mysql_query("SELECT * FROM users");
while($data = mysql_fetch_array($result))
$pm = $data['pm'] ;
$pm = $pm + 1 ;

 mysql_query("UPDATE users SET pm = '$mp' WHERE (username='$pm_to')") or die (mysql_error());

[laserlight]

Yes, because you're setting pm to $mp instead of $pm.

[Acceptu]

i edited that and still does not update it
it just stays on 1

$username = $SESSION['username'];
$pm_to = $POST['pm_to'];
$pm_subject = $POST['pm_subject'];
$pm_msg = $POST['pm_msg'];
$pm_time = date("F j, Y, g:i a");

mysql_connect("local
mysql_select_db(";
$result = mysql_query("SELECT * FROM users");
while($data = mysql_fetch_array($result))
$pm = $data['pm'] ;
$pm = $pm + 1 ;

?>
<?
mysql_query("UPDATE users SET pm = '$pm' WHERE (username='$pm_to')") or die (mysql_error()); ?>

still don't work

[laserlight]

$username = $_SESSION['username'];
$pm_to = $_POST['pm_to'];
$pm_subject = $_POST['pm_subject'];
$pm_msg = $_POST['pm_msg'];
$pm_time = date("F j, Y, g:i a");

mysql_connect(/* etc */);
mysql_select_db(/* etc */);
mysql_query("UPDATE `users` SET pm=pm+1 WHERE username='$pm_to'")
	OR die (mysql_error());