? How do I check db if user exists update else insert?

[twtFollow]

I'm trying to setup a twitter script that will update a users description, url, and photo.

I've got everything working where it will insert, I was trying to use the replace function but not having any luck, here's what I have so far:

$xml = new SimpleXMLElement($xmlstring);
$pimage = $xml->profile_image_url[0];
$pdesc = $xml->description[0];
$purl = $xml->url[0];

$process_profile = "REPLACE INTO twitter_cache SET twitter_user ='$twid', pimage = '$pimage', pdesc = '$pdesc', purl = '$purl'";
mysql_query($process_profile)
or die(mysql_error());

[X-Cart]

First of all, you need to make sure there's a column which contains an unique value, otherwise a new record will be inserted. Could you provide a table structure for twitter_cache?

[decowski]

INSERT ... ON DUPLICATE KEY UPDATE

[twtFollow]

table structure is:

twitter_user varchar(255) utf8_unicode_ci
pimage varchar(255) utf8_unicode_ci
pdesc varchar(255) utf8_unicode_ci
purl varchar(255) utf8_unicode_ci

[twtFollow]

So would this work?
INSERT INTO table (twitter_user,pimage,pdesc,purl) VALUES ($twitter_user,$pimage,$pdesc,$purl)
ON DUPLICATE KEY UPDATE pimage=$pimage, pdesc=$pdesc, purl=$purl;

-is the syntax right as well?

btw - I've made twitter_user 'unique'

[X-Cart]

In case twitter_user is unique, both versions should work.