Query

[leoxdnardo]

i have this query
UPDATE `accounts` SET `premium_points`='$ProdQuantidade_x' WHERE name = '$ProdID_x';

this will set premium points = $ProdQuantidade_x in the account name $ProdID_x
is there a way to add and not set
i tried this and it didnt work
UPDATE `accounts` ADD `premium_points`='$ProdQuantidade_x' WHERE name = '$ProdID_x';

 

[Summ]

UPDATE `accounts` SET `premium_points`=`premium_points`+'$ProdQuantidade_x' WHERE name = '$ProdID_x';

 

[leoxdnardo]

and how can i execute this query in php?

 

[Zaul]

Mabye if you learn php you will know to next time? Search for newboston in youtube.

<?php

$con = mysql_connect('localhost', 'root' 'password');
mysql_select_database('Databasename');

if(! $con){

mysql_query("

UPDATE `accounts` SET `premium_points`=`premium_points`+'$ProdQuantidade _x' WHERE name = '$ProdID_x'; ");

}else {
echo "Somthing is wrong here.";
}

?>