Update and refresh

[VinnyWolf]

I have an inventory page where the quantity is displayed in a text box so the user change the value and then click a "submit" button and I think I have the code figured out as to how to update the MySQL database. My question is how to refresh the inventory page to reflect the new, updated inventory after "submit" button is clicked, rather than go to a page stating that the "query was successful" and then prompting the user to click "here to return to the inventory page"

Thanks in advance for any help or suggestions.

Vinny

[leatherback]

Hi,

If you do the update in the same page, you can check:

if($POST[formsubmitted] == 1)
  {
  // process the submitted form:
   mysql_query(update table set (... = ...) where ... = ... );
  }

// now you can retrieve the page here

[Sxooter]

Use a meta refresh tag with a target field and a refresh time of like 5 seconds. It's in the html4.0 docs somewhere. Any web page that redirects you after a short is usually using this, so it's easy to find one to scope out the source on it.