mysql delete

[parxal]

i am making a table for each row in database:
while ($row = mysql_fetch_array($result))
{
</table>
<tr>
printf("<td bgcolor=\"#FFFFFF\">Name: %s",$row["name"]);
printf("<br>Morada: %s</br>",$row["morada"]);
printf("Url: %s",$row["url"],"</td>");
</tr>
</table>
}
Is it possible, to make a button in each table, to delete that row in my database?

[Oleg Butuzov]

i am making a table for each row in database:
while ($row = mysql_fetch_array($result))
{
</table>
<tr>
printf("<td bgcolor="#FFFFFF">Name: %s",$row["name"]);
printf("<br>Morada: %s</br>",$row["morada"]);
printf("Url: %s",$row["url"],"</td>");
</tr>
</table>
}
Is it possible, to make a button in each table, to delete that row in my database?

YES
make a script widh will delete MYSQL records for ex del.php


while ($row = mysql_fetch_array($result))
{
</table>
<tr>
printf("<td bgcolor="#FFFFFF">Name: %s",$row["name"]);
printf("<br>Morada: %s</br>",$row["morada"]);
printf("Url: %s",$row["url"],"</td>");
echo "<td><form method=post action=dele.php target=_blank><input type=hidden value=o name=id><input type=submit calue=delete></form></td>";
</tr>
</table>
}


In del.php

Code: Select all

mysql_query(DELETE FORM `tablename` WHERE `id` = '$id");