I'm so close to getting this to work. I have everything working now except for one minor (hopefully) issue. I have an html table display the data from a mysql database. At the end of each line I have an Edit button, that button then should pass the ID to the edit php script. It does display an edit form in table format which is how I have it designed but when I click one Edit button it brings up the whole mysql table. The display form is a php script that executes edit.php when one of the edit buttons is clicked.
display.php
edit.php
display.php
Code:
<?php
// connection stuff is here
$result = mysql_query("SELECT * FROM Items");
echo '<form action="edit_form.php" method="post">';
// table and form stuff is here
echo "<td><input name=\"update\" type=\"submit\" value=\"Edit\"</td></tr>";
edit.php
Code:
// connection stuff
$query = ("SELECT * FROM Items WHERE id = id") or die("Unable to search ID: " . mysql_error());
// table headers
while($row = mysql_fetch_array($result)) {
// table containing data -- everything from here out works fine.







