table amend button at each table row

i just had a list of events that i have 3 posible options for, OPEN, LIMITED, CLOSED. I have preset all items to OPEN within the database, but would like the ability to amend these as and when needed, rather than generate a unique link at the end of the row which then loads the next page with essentially a drop down box and a button to update the value i thought i could cut a corner and simply put the drop down box at the end of the row and either have one button to update all values with whatever has been set for each of the drop down boxes OR simply have a submit button at the end of each row.

it doesnt need to load anything else when changed, as the user could change their mind which is why i choose to keep it simple and use a button ? im guessing if i wanted it to trigger an event then i would need to use java?

If I am understanding you correctly you would have a page displaying rows of data with an option to change the row event to either OPEN, LIMITED, or CLOSED Right?

Continuing to understand your question; you are unsure of these two scenarios.

1) Whether or not to populate a drop-down box with the row data and have another drop down box with the event type: OPEN, LIMITED, or CLOSED and a corresponding button to update the database.

2) To list each row and on each row consisting of a event OPEN, LIMITED, or CLOSED with a button to update the database.

Either way it goes, populating the database with the values from the form is going to need a POST or GET to something that processes the data. Whether you post it to itself or another script, something will need to handle the data.

In my opinion, when you loop through the rows in the database, you can create a form for each row all posting to the same script that processes the data.


<?php
// Assuming youve already connected to the database

// Execute Query
$sql="SELECT id, thing FROM table";
$result=mysql_query($sql);

// Loop through the rows from the database and create a form with a submit button to post the values to a process.php

while ($row=mysql_fetch_array($result)) {
    echo "<form action='process.php' method='post'>";
    echo $row['id'].<input type='hidden' name='row' value='".$row['id'];
    echo "<select name='event'><option value='0'>OPEN</option>";
    echo "<option value='1'>LIMITED</option>";
    echo "<option value='2'>CLOSED</option>";
    echo "</select><input type='submit' name='submit' value='Update'></form>";
}

?>

Have the process.php handle the variables $row and $event and update the database row that corresponds with the $row.

i already have the code similar to what you have posted, if i wanted to post the page to the same page instead of process.php, how would i go about that and to ensure it doesnt conflict with any of the other code on the same page.