How to overwrite table data?

[iceflyin]

'user' is a number, and the index.

$sql="INSERT INTO userInfo (user, rssURL) VALUES ('$_POST[user]','$_POST[rssURL]')";

When I run the code a second time, it gives me:
Error: Duplicate entry '19717633' for key 1


I think I need to have something before it like... Puesedocode: if exists select from userInfo (user), drop rssURL, then insert new rssURL at index(user)

Or, is there a way to overwrite entries?

[undertaker78]

If value already exists then you can update the record
$sql = "update userInfo set rrsURL = '$_POST[rssURL]' where user = '$_POST[user]'

[iceflyin]

Sweet, thanks!

[guelphdad]

or even better, do both at the same time


$sql="INSERT INTO userInfo (user, rssURL) VALUES ('$_POST[user]','$_POST[rssURL]')
ON DUPLICATE UPDATE
set rrsURL = '$_POST[rssURL]' where user = '$_POST[user]'";

[iceflyin]

Already did that. Thanks though.

Heh... This is kinda funny. I am kinda new to PHP, and couldn't figure out the syntax to integrate undertakers code. So, I actually never used his, it just set me on the right track:


$sql="INSERT INTO userInfo (user, rssURL, imageURL, feedSource) VALUES ('$_POST[user]','$_POST[rssURL]','$_POST[imageURL]','$_POST[feedSource]') ON DUPLICATE KEY UPDATE rssURL= '$_POST[rssURL]', imageURL= '$_POST[imageURL]', feedSource ='$_POST[feedSource]'";