[SOLVED] Query affected rows

[EchoFool]

Is there a way to check that my query has actually deleted a row. I cannot tell for sure if its being deleted and then re-created.

 

Is there like a check for affected rows or something?

 

I have this:

$GetFight = ("DELETE FROM attack WHERE Attacker='{$_SESSION['Current_User']}'")
				Or die(mysql_error());

 

And it doesn't delete my row. It's quite irritating as i do not know why. Hope you can help.

[pocobueno1388]

Your not using mysql_query. Change your code to this:

 

<?php

$GetFight = mysql_query("DELETE FROM attack WHERE Attacker='{$_SESSION['Current_User']}'")
				or die(mysql_error());

?>

 

 

[EchoFool]

LOL man thats got to be a sign that i need a break! Good spot. Can't believe i didn't see that. 

 

Thankyou!

[teng84]

$GetFight = mysql_query("DELETE FROM attack WHERE Attacker='{$_SESSION['Current_User']}'") or die(mysql_error());
if($GetFight ){
//yes
}else{
//no
}
echo msql_affected_rows($GetFight);//returns the number of affected rows

pocobueno1388 beat me