'replace' with 'where'

From: Date: Fri, 10 Aug 2001 03:47:00 +0000
Subject: 'replace' with 'where'
Groups: php.db 
Request: Send a blank email to php-db+get-11206@lists.php.net to get a copy of this message
hello php-db people. i'm wondering if you could set me straight here. here's my code snippet: $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. bla.com/page.php?id=3). i'm wondering if the 'where' syntax works with replace because i need to essentially edit a record via the web. i've checked on the mysql.com manual and it doesn't specify this (or at least i couldn't find it). thanks again, Matt

« previous php.db (#11206) next »