[RESOLVED] Deleting Row Based on ID

brendan2b

I have a photo gallery with each images information inserted into a row, and each image has a unique id.

I have a image deletion option above each image. This code that I have deletes the last row in the database for some reason, even though each image corresponds to a unique username.

Can anyone help me with this code and let me know what seems to be the problem, or help me with a row deletion based on unique id.


<?

session_start();
$username = $_SESSION['username'];
if ($_SESSION['logged']!==true)
 {
   header('location:loginfailed.php');

} 
else {

$imageID = $_SESSION['imageID'];

$sql = "DELETE FROM user_photos WHERE imageID=$imageID";
$result = mysql_query($sql);


}



?>

FOR SOME REASON MY CODE DELETES THE LAST ID IN THE DATABASE NO MATTER WHAT PICTURE I CLICK TO DELETE.

The url for the deletion page is a querty URL

delete.php?imageID=$imageID

Someone please help me. It will be most appreciated.

Roger_Ramjet

If it deletes the last id then that must be what is in $SESSION['imageID']. It does not matter what is in the url with your code, it does not reference it. So where is that id being set in $SESSION['imageID']?

brendan2b

Roger,

On the my album page there is an array of everything in the database corresponding to that users username. It displays all their images, 3 per row in a while loop. I have the $_SESSION['imageID'] in each loop meaning that it will of course be equal to the last value no matter what, so I have figured out that part. My question is where do I need to put that in order to assign each picture correctly with its ID, and as well as put that in a session variable.

Roger_Ramjet

Your whike loop needs to build the link like this

$link = 'delete.php?imageID=' . $_SESSION['imageID'];

// then delete.php acceses it like this

$id = $_GET['imageID'];

You pull it from the GET vars not from session

brendan2b

Wow thank you so much. That works perfectly now. Flawless.