MySQL

Delete rows from database

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Oct 2008

Posts: 89

Reputation: sfrider0 is an unknown quantity at this point

Solved Threads: 0

sfrider0

Offline

Junior Poster in Training

Delete rows from database

Jul 27th, 2009

I'm trying to delete rows from my database by using an HTML form. I can retrieve the database and display it nicely in a table using this code:

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
<table width="889" border="1">
	    <tr>
	      <td width="206" bgcolor="#999999"><div align="center"><strong>Site</strong></div></td>
	      <td width="549" bgcolor="#999999"><div align="center"><strong>Reason</strong></div></td>
	      <td width="112" bgcolor="#999999"><div align="center"><strong>Date Added</strong></div></td>
        </tr>
<?php
$row_count = 0;
$columns = 3;
while ($row = mysql_fetch_assoc($result)) {
if ($row_count == $columns) {
echo "</tr><tr>";
$row_count = 0;
}
echo "<tr><td>";
echo $row['Site'];
echo "</td><td>";
echo $row['Reason'];
echo "</td><td>";
echo $row['Date'];
echo "</td>";
$row_count++;
}
?>
</tr>
</table>
<table width="889" border="1">
	    <tr>
	      <td width="206" bgcolor="#999999"><div align="center"><strong>Site</strong></div></td>
	      <td width="549" bgcolor="#999999"><div align="center"><strong>Reason</strong></div></td>
	      <td width="112" bgcolor="#999999"><div align="center"><strong>Date Added</strong></div></td>
        </tr>
<?php
$row_count = 0;
$columns = 3;
while ($row = mysql_fetch_assoc($result)) {
if ($row_count == $columns) {
echo "</tr><tr>";
$row_count = 0;
}
echo "<tr><td>";
echo $row['Site'];
echo "</td><td>";
echo $row['Reason'];
echo "</td><td>";
echo $row['Date'];
echo "</td>";
$row_count++;
}
?>
</tr>
</table>

Now I would like to add a checkbox beside each item that will delete it. Possibly be able to check multiple items and delete them by clicking a Delete button at the bottom of the table. Can anybody help me get started or point me to a good tutorial? Any help would be greatly appreciated.