'replace' with 'where'
| From: | Matt Nigh | 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