RE: [PHP-DB] 'replace' with 'where'

<snip> > $result_insert = mysql_query("replace into wantlist where id = > '$id' values ('', '$artist', '$title', > '$tracks', '', '', '')"); > the $id is already defined in the url, by the way (ex. <snip> The way replace works is it looks for a unique index key in your update list, if it finds one it uses that key to determine where the REPLACE is done. The update command would probably work better for you if all you're wanting to do is change column values of a record already stored in the table. It's also much easier and versatile Sincerely, Craig Vincent