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

kaos057

Change $row[id] to just $id and on the link that deletes the selected message, use something like
<a href="http://www.whatever.com/page.php?id=<? echo $row['id']?>Delete Message</a>

That is going by what I see. If you want to paste more code I could probably be a lot clearer.

Newbie567

If i change to $id i get an unidentified variable error. 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 = $row[id] ";

siwis

Try adding the following line and then modifying your sql:

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

Also, just a quick bit of advice that may save you hours in the future.... Get into the habit of using $var['column_name'] ie bound your column names with single quotes.