if doesnt exist then create, else just update

[Dan13071992]

hello everyone, im curious as to how i would go about writing a script that would create a row if it doesnt already exist, but if it does exist then just update that row.

What would be the best way to do this?

Thanks.

Dan

[myfayt]

We need more information on what you're trying to do. Are you looking to match like a username or what? Thanks

[Dan13071992]

thanks for the reply.

it would need to be constructed like this:

if ($strTitle) doesnt exit in table create row, elseif it does exist uodate "views" +1 where pagename = $strTitle

[Dormilich]

something like INSERT INTO ... ON DUPLICATE KEY UPDATE ... ?

[Dan13071992]

could you elaborate a little more please, maybe with a small example, as ive never used this before.

thanks.

Dan

[Dormilich]

a whole explanation

[Dan13071992]

that is bang on exactly what i want thank you, ill report back with what i get and if it works or not

thanks once again

Dan

[Dan13071992]

ok, so ive looked into it, and ive wrote it like this, however, it neither inserts, nor updates :S

PHP Code:

mysql_query("INSERT INTO pageviews (pagename,views) VALUES ($strTitle,0) ON DUPLICATE KEY UPDATE views=views+1"); 


have i gone wrong somewhere?

[Dan13071992]

ive tried the above mysql_query (from my previous post) on a couple of different pages, however i have still not managed to get it to work, any ideas why? am i doing it wrong?

[myfayt]

Hmm I believe you need single quotes in the values. I code these differently, but in this format, try:

PHP Code:

mysql_query("INSERT INTO pageviews (pagename,views) VALUES ('$strTitle','0') ON DUPLICATE KEY UPDATE views=views+1"); 


[Dormilich]

you need the quotes for the string value, integers are used without.

mysql_query("INSERT INTO pageviews (pagename, views) VALUES ('$strTitle', 0) ON DUPLICATE KEY UPDATE views=views+1");