UPDATE MySQL through PHP

[edzeak]

I am "pulling" a table of data from MySQL, with the possibility of one (1) field being empty. If this field is empty the user can enter data and click submit. Once the submit is clicked the user should be presented with the same table that lists the same data AND the updated information.

I have everything working except the update function. Are there any tricks to this? I am doing this all on one (1) page, using ".$PHP_SELF."

Thanks.

[amcgrath]

Well, one suggestion would be to perofrm the update/delete/insert first, maybe surrounded with a $REQUEST_METHOD and $HTTP_POST_VARS check, then select the new data set.