[Resolved] If doenst exist then...

[Manat]

Hi all,

$bstats = "UPDATE tableName SET hits = hits + 1 WHERE word= $word";

$bresults = mysql_query($bstats) or die(mysql_error());

when the $word variable gets passed, increment a counter in the db. But what if that $word doesn't already exist, how do I create that record and assign 1 to it?

[Trs2988]

There might be an easier way, but this should work...

if(mysql_num_rows(mysql_query("select word from tableName where word='$word'"))) {
mysql_query("update tableName set hits=hits+1 where word='$word'") or die (mysql_error());
}
else {
mysql_query("insert into tableName (word,hits) values ('$word',1)") or die (mysql_error());
}