Hi,
I have a survey (Ideas) page that submits into a MySQL Table. I also have a results page
That loks like this:
[CODE]<?php
$con = mysql_connect(“localhost”,”username”,”password”);
if (!$con)
{
die(‘Could not connect: ‘ . mysql_error());
}
mysql_select_db(“database”, $con);
$result = mysql_query(“SELECT * FROM ideas”);
echo “<table border=’1′ align=’center’ cellspacing=’0′ class=’sub2′ cellpadding=’2′ width=’85%’ bordercolor=’black’>
<tr>
<th class=’header’ colspan=’1′ align=’center’>Id</th>
<th class=’header’ colspan=’1′ align=’center’>Date and Time</th>
<th class=’header’ colspan=’1′ align=’center’>Username</th>
<th class=’header’ colspan=’1′ align=’center’>Idea</th>
</tr>”;while($row = mysql_fetch_array($result))
{
echo “<tr>”;
echo “<td>” . $row[‘id’] . “</td>”;
echo “<td>” . $row[‘datetime’] . “</td>”;
echo “<td>” . $row[‘username’] . “</td>”;
echo “<td>” . $row[‘idea’] . “</td>”;
echo “</tr>”;
}
echo “</table>”;mysql_close($con);
?>
Is there any way I can also have a Delete button that only deletes that row? and Also is there a way that I can have a button that transferrs it into a another Table?
Thanks Guys,
Ash