Search the Community

What I want to do is update the date/time field when the check box or a button is selected for that specific row only. on clicking the button it should get the current date and time and store it into the database in the date/time field. Is this possible to do? here is a snapshot of my code so far. <?php $query1 = "SELECT * FROM software"; $result1 = mysql_query($query1); $id = $row['SoftwareID']; $time = time(); $timestamp = $_POST[date('Y-m-d H:i:s', $time)]; $query2 = "UPDATE software SET timestamp = '$timestamp' WHERE SoftwareID = '$id'" ; ?> <br> <table border ="1" width="justified" <tr> <th><center>Version Number </th></center> <th><center>Defect Number</th> <th><center>Description</th> <th><center>Date/Time</th> <th><center>Ready?</th> </tr> <?php while ($row = mysql_fetch_array($result1)) { $versionnumber = $row['VersionNumber']; $defectnumber = $row['DefectNumber']; $description = $row['Description']; $timestamp = $row['timestamp']; ?> <tr> <td><?php echo $versionnumber; ?></td> <td> <?= $defectnumber ?></td> <td> <?= $description ?></td> <form action="" method="post"> <td> <?= $timestamp ?></td> <td> <input type="submit" value="Submit Time"></td></form> </tr> <?php } ?> </table> </br> insert.php <?php include("databaseConnection.php"); $versionnumber = $_POST [versionnumber]; $defectnumber = $_POST [defectnumber]; $description = $_POST [description]; $qry = "INSERT INTO software (versionnumber, defectnumber, description) VALUES ('$versionnumber','$defectnumber','$description')"; $result = mysql_query($qry); if ($result) { echo "information submitted, "; header("location: developer_dashboard.php"); exit(); } else { die("There was an error, try again later"); } ?>