mysql_query

[Janka no Benzin Tanka]

Ir datubāze ar vienu tabulu "points" (username, points).

Man vajadzīgs mysql_query(), lai izdarītu šādu funkciju:

Ja iekšā tabulā jau ir tāds username, tad pieskaita punktus;

Ja tabulā nav tāds username, tad ieraksta pa jaunu username un punktus.

 

Palīdziet uztaisīt precīzu kodu. Pagaidām ir šāds, bet nestrādā kā vajag.

 

$run111 = mysql_query("SELECT * FROM `points` WHERE `username` = '$name'");
if (mysql_num_rows($run111) > 0) {
mysql_query("UPDATE INTO `points` (`points`) VALUES ('1') WHERE username = '$name'");
}
mysql_query("INSERT INTO `points` (`username`, `points`) VALUES ('$name', '1')");

Edited May 11, 2010 by Janka no Benzin Tanka

[m8t]

http://www.w3schools.com/php/php_mysql_update.asp

mysql_query("UPDATE `points` (`points`) VALUES ('1') WHERE username = '$name'");

[anonīms]

$eksiste = mysql_result(mysql_query("SELECT count(points) FROM `points` WHERE `username` = '$name'"),0,0);
if($eksiste) > 0) 
{
mysql_query("UPDATE points SET points = points+1 WHERE username = '$name'");
}
else
{
mysql_query("INSERT INTO `points` (`username`, `points`) VALUES ('$name', '1')");
}

tipa tago?

[mefisto]

INSERT INTO points( username , points ) VALUES ( 'foobar' , 42 ) ON DUPLICATE KEY UPDATE points = VALUES( points )