Re: Update Status Question
| From: | Tom Rogers | Date: | Thu, 13 Mar 2003 01:32:03 +0000 |
| Subject: | Re: Update Status Question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-139425@lists.php.net to get a copy of this message | ||
Hi,
Thursday, March 13, 2003, 6:10:29 AM, you wrote:
MW> Hello:
MW> I have this line:
MW> $sql = "Update Members Set Active='Y' where Username = '$_GET[UN]'
MW> And
MW> ActiveCode = '$_GET[ID]'";
MW> Is there a php function that will return true or false or something when
MW> this is processed. I.E. if the Where clause fails it would report back
MW> fail? Or do I first need to check the status with a select?
MW> Thank you,
MW> Mike Walth
MW> CinoFusion
If using mysql you can use
if(mysql_affected_rows()){
echo 'Success';
}else{
echo 'Oops';
}
--
regards,
Tom