Re: [PHP3] MySQL entry removal From: Mark Lo (markloky <email protected>)
Date: 04/30/00

Tyler Longren wrote:

> I'm having a problem having the correct message displayed if the user
> is successfully deleted or if the user isn't successfully deleted.
> Here's my code: <?$db = mysql_connect("localhost","root","password")
> or die ("Unable to connect to MySQL
> server.");mysql_select_db("secretDB",$db) or die ("Unable to select
> requested database.");$deleteresult = mysql_query ("DELETE FROM
> users WHERE real_name =
> '$real_name' AND username =
> '$username' ");
> $result=mysql_query($deleteresult, $db);
> $affected_rows=mysql_affected_rows( $db);
>
> if ($affected_rows>0)
> { print (" Successfully Updated");}
> else
> {print("Unsuccessfully Updated");}
>
>
>
>
> Can anybody help me out here? I had this problem once and was able
> to fix it, but I don't remember what I did. Thanks! Tyler Longren