how delete comment row from mysql using html buton

[joni20]

html body mysql result:

<?
$sqlcomments = "SELECT * from sellercomments where Status=1 and SellerID=".$_REQUEST['SellerID']. " order by AddedDate desc";
$resultcomments= mysql_query($sqlcomments);
if (@mysql_num_rows($resultcomments)!=0){
?>
<br>
<?
while($row_comments = @mysql_fetch_array($resultcomments))
{
?>
<div align="right"><img src="../<?=$row_sellerdetails['AboutUsImage']?>" width="40" height="40" border="0"></div>
<?=$row_comments['CommentBy']?>] to <a href="index.php?SellerID=<?=$_REQUEST['SellerID']?>">
<?=$row_sellerdetails['idName']?></a>
<span style="color:#000000"><?=$row_comments['Comment']?></span> <br>
<?
}
}
?>  

------ end: want to delete this comment result?>>>

[LastMitch]

how delete comment row from mysql using html buton

You can read and try this example:

http://www.ehow.com/how_12105351_delete-row-mysql-using-php-button.html

[Szabi Zsoldos]

you can set a variable and use an id

<a href="?delete=<?php echo $row('id'); ?>">Delete</a>

if(isset($_GET['delete']) && !empty($_GET['delete'])) {
    $sql = mysql_query("DELETE FROM yourTable WHERE id = '".mysql_real_escape_string($_GET['delete'])."'");

    if(!$sql) {
        echo 'Error during delete #'.mysql_error()';
    }
}