Re: Re: SQL Insert INTO question
| From: | Graham Cossey | Date: | Thu, 08 Dec 2005 21:22:12 +0000 |
| Subject: | Re: Re: SQL Insert INTO question | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-40815@lists.php.net to get a copy of this message | ||
<snip>
How about:
$review = $_POST['review'];
$sql = "SELECT * FROM reviews WHERE review_id = '$id'";
$res = mysql_query($sql) or die ("Query failed: " . mysql_error());
if (mysql_num_rows($res) > 0)
{
$sql_upd = "UPDATE reviews
SET review_text = '$review'
WHERE review_id = '$id' ";
$res_upd = mysql_query($sql_upd) or die ("Query failed: " . mysql_error());
}else{
$sql_ins = "INSERT INTO reviews (review_id, review_text)
VALUES('$id', '$review')";
$res_ins = mysql_query($sql_ins) or die ("Query failed: " .
mysql_error());
}
--
Graham