delete a row in mysql

hansman

hi, i currently have all my mysql data displayed in a tabe. I would like to add a button to delete all the data in the row. Can some please assit me in doing this. Thank you in advance

<html>
<head>
<title>Displaying MySQL Data</title>
</head>
<body>
<p>
  <?php
$db_host="xxxxxxt"; // Host name
$db_user="xxxxxxxx"; // Mysql username
$db_pwd="xxxxxxxx"; // Mysql password
$db_name="xxxxxxxx"; // Database name




mysql_connect($db_host, $db_user, $db_pwd);
mysql_select_db($db_name);

$query="select * from test_mysql";
$result=mysql_query($query);
echo "<table border=1>";
echo "<tr>";
for($i=0;$i<mysql_num_fields($result);$i++)
{
    echo "<th>";
    echo mysql_field_name($result, $i);
	echo "</th>";
}

while($row=mysql_fetch_row($result))
{
    echo "<tr>";
    for($j=0;$j<$i;$j++)
    {
    echo "<td>";
    echo $row[$j];
    echo "</td>";
    }
    echo "</tr>";
}
echo "</tr>";
echo "</table>";

?>
</p>
<p><a href="http://www.xxxxx.com/insert.php">Click Here to Enter More data!</a></p>
</body>
</html>

compbry15

per the MySQL documentation, the following query can be used to delete a row:

DELETE FROM test_mysql WHERE "whatever criteria, i.e id=20"

hansman

but how would i be able to implement that into the table, such that i can run the query when the DELETE link next to the table is clicked

leatherback

you create a link with the id of th record to delete:
<a href="delpage?recordid=12">delete</a>
On the next page you $_GET['recordid'] to use in the query. Make sure you sanitize the code & make sure you know who has access to the delete...