Editing Query Results

[matthewroth]

hoping i could get a nudge in the right direction. I get all these results back from my table but i want to be able to click on the ID for any given row in order to update the fields.

<?
include_once("../sql_connect.php");

$getchecklistSql = "SELECT * FROM checklist WHERE TIME BETWEEN '06:00:00' AND '18:00:00' ORDER BY Time ASC";
$getchecklistResult = mysql_query($getchecklistSql);


echo "<table border='1'>
<tr>
<th>ID</th>
<th>Event</th>
<th>Time</th>
<th>Shift</th>
</tr>";while($row = mysql_fetch_array($getchecklistResult))
  {
  echo "<tr>";
  echo "<td>" . $row['Item'] . "</td>";
  echo "<td>" . $row['Event'] . "</td>";
  echo "<td>" . $row['Time'] . "</td>";
  echo "<td>" . $row['Shift'] . "</td>";
  echo "</tr>";
  }
echo "</table>";
?>

[TheServant]

So you only want to update one row? Why don't you just have a refresh button to update all rows?