It won't let me delete a row

reub77

I've done this beforebut it's not working for me now. This is the code I am trying:

if($act=="DELETE"){
$query = "DELETE FROM movies WHERE movieName='".$id."' AND owner='".$own."'";
}

The only difference from the way I did it the last time is that I have an AND in there. If you need to see more of the code let me know. I can't show it all as it's not secure. I've put flags up to show me what is working and what isn't. As far as I can see the $act variable is being made equal "DELETE", the $id does equal the appropriate movie title, and the owner $own does equal $own. And this is all true inside the if statement where I query the database. So I'm thinking the error is inside the if statement.

Thanks

cgraz

3 suggestions:

The most obvious: All you have is a variable with a string that you would like to execute. However you don't execute it. use mysql_query()

Print the string to see if those variables within the string are being passed properly, or else your string is empty.
echo something inside of that if statement so you can see if the if statement is even being evaluated the way you would like.

Cgraz