Updating MySQL DB - Newbie

[thekidscareya]

I'm having a bit of problems working with PHP/MySQL technology.

MySQL Query

SELECT tblStatus.Name, tblApplication.Reason, tblApplication.Hosting, tblApplication.Email FROM tblStatus INNER JOIN

tblApplication ON tblStatus.StatusID = tblApplication.Status WHERE (((tblStatus.Name)="Applying"));

---

Data in tblStatus

LOCK TABLES tblStatus WRITE;
INSERT INTO tblStatus VALUES(1, 'Applying');
INSERT INTO tblStatus VALUES(2, 'Accepted');
INSERT INTO tblStatus VALUES(3, 'Rejected');
INSERT INTO tblStatus VALUES(4, 'Acceptance Email Sent');
INSERT INTO tblStatus VALUES(5, 'Rejection Email Sent');
UNLOCK TABLES;

---

I want to be able to change Applying from tblStatus.Name to any of the other values within that table...eg. Accecpted,

Rejected, etc.

I want to create a php page that performs the mysql query above, but puts the tblStatus.Name into a combo box. I would also

like to have a save button to save any changes I make to tblStatus.Name.

I know how to preform MySQL queries and update data from MySQL. The problem is that I don't know how to do that on one page.
How can I do that?

[bretticus]

Do you mean query the data, put it in a combobox, and after submitting, update the data all in one script?

[thekidscareya]

Yep

[bretticus]

if statement like...

if($_POST['submit']) {
//do the update query
} else {
//query for the combobox
//show the form (action should be $_SERVER['PHP_SELF'])
//loop through the query results to show the combobox.
//make the values the id of the record which you'll pass to this script and capture in the top if block.
}

If you would like me to be more specific, please show me some code you have produced thus far. I can help you from there.