Please help! Cant delete messages in my guestbook.

[Newbie567]

When i am to delete one message all of the messages in my guestbook gets deleted. I changed $row[id] to a number and then only one row is deleted. However then of course i cant delete more than one row. If anyone knows what i´ve done
wrong i would appricate it.

$query = "DELETE FROM guestbook WHERE id = $row[id] ";

Thanks

[nnichols]

Presumably you have a button or link with each message which creates a get request or posts a form. You need to insert the row[id] in that request, so you generate something like -

http://domain.com/delete.php?id=7 (number generated from the row[id] for the message)

This then gives you the $GET['id'] available in the next page so you can do -

$query = 'DELETE FROM guestbook WHERE id=' . $_GET['id'];

Hope this helps 😉

P.S. If not post your complete code so we can have a look

[keith73]

When i am to delete one message all of the messages in my guestbook gets deleted. I changed $row[id] to a number and then only one row is deleted. However then of course i cant delete more than one row. If anyone knows what i´ve done
wrong i would appricate it.

PHP:

$query = "DELETE FROM guestbook WHERE id = $row[id] ";

Well what do you want the query to do?
If you don't specify the id in the WHERE clause, then it will delete all rows. IF you use the WHERE clause and specify the id, it will delete any row that has that id. the ID is probably unique which means only one row has that ID.

If you want to delete all messages from [e-mail] they you would use this query:

DELETE FROM guestbook WHERE email = '[e-mail]'

Every row where guestboook.email = [e-mail] will be deleted.

Please be more specific about what the app does, and what you want it to do if you still need help. And please post some code.

• keith

[Newbie567]

Thanks for the help so far.
"You need to insert the row[id] in that request"
How do i do that?
I have a delete buttom on every message, and when i click on it
it is supposed to delete that message. here is some more code:

<?
while($row =  mysql_fetch_array($result))
{
echo "<br><table width = '500' border = '2' cellspacing = '3' cellpadding = '2'>
<tr>
<td>Namn: $row[name]</td>

<td>Email: $row[email]</td>

<td>Skickat: $row[date]</td>
</tr>
<tr>
<td colspan = '3'> $row[message] </td></tr>

 ";

if(isset($_POST['radera'])){
$query = "DELETE FROM guestbook WHERE id = ' . $_POST['id']; ";

mysql_query($query);
}

if(isset($_SESSION['Admin'])){
?>
<tr><td>
<form action = "<? echo $_SERVER['PHP_SELF']; ?>" method = "POST">
<input type = "submit" name = "radera" value = "Radera">
</tr></td></table>
<?

}
}
mysql_close($conn);

?>

</body>
</html>

[nnichols]

Try changing your form inside the while loop to this -

<tr><td>
<form action = "<? echo $_SERVER['PHP_SELF']; ?>" method = "POST">
<input type = "hidden" name = "id" value = "<? echo $row['id']; ?>">
<input type = "submit" name = "radera" value = "Radera">
</tr></td></table>

Hope this helps 😉

[Newbie567]

Thanks for your time, it worked!