[SOLVED] PHP remove rows from database

[daveoffy]

I have this

$memberid = $_SESSION['SESS_MEMBER_ID'];
$friendid = $_GET['FRIEND_ID'];
$sql = "DELETE FROM friends WHERE member_id = '$memberid' AND friend_id = '$friendid'";
$result = mysql_query ($sql);
if ($result) {
	Header('Location: friend-remove-success.php');
	}else{
echo "Query Failed";}

It goes to the header location but it doesn't delete the row where memberid and friend id are the same.

[revraz]

Echo $sql and see what the variables contain.

Use mysql_error() after your query to see if any errors are reported.

[daveoffy]

It says

DELETE FROM friends WHERE member_id = '' AND friend_id = ''

I guess it can't pull memberid and friendid

[daveoffy]

I fixed it. I was my fault. The .htaccess was making it friend_id not FRIEND_ID. Also the session was not working because I did not put session_start()