DaniWeb Forum Index > Web Development > PHP

Updating required 2 Clicks of the same button

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2007

Posts: 608

Reputation: OmniX is an unknown quantity at this point

Solved Threads: 8

OmniX

Offline

Practically a Master Poster

Updating required 2 Clicks of the same button

May 16th, 2008

Problem is:
I click my submit button it updates the database but not the website content, I click the submit button again and it updates the website content this time.

This problem always pops up, and its due to incorrect structure of code in most parts

I cant seem to remember what structure I should have my code set out to (updates, selects, etc and in which order) - as it seems complex yet correct.

So anyone lead me in the right direction? Thanks

PS: I use the below code to refresh the page:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
header('refresh: 0; url=test.php');
header('refresh: 0; url=test.php');

•

Join Date: Jan 2008

Posts: 79

Reputation: rudevils is an unknown quantity at this point

Solved Threads: 9

rudevils

Offline

Junior Poster in Training

Re: Updating required 2 Clicks of the same button

May 17th, 2008

try it like this

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
 if($submit){
   $query = "your update query";
   $result = mysql_query($query);
   if($result){
       header("Location: yourpage.php");
   }
}
 if($submit){
   $query = "your update query";
   $result = mysql_query($query);
   if($result){
       header("Location: yourpage.php");
   }
}

after u submit the button, your current page will redirect automatically to yourpage.php

If love is blind, why there's a bikini ??

Post your article at Bali Side Notes share your knowledge

•

Join Date: Dec 2007

Posts: 608

Reputation: OmniX is an unknown quantity at this point

Solved Threads: 8

OmniX

Offline

Practically a Master Poster

Re: Updating required 2 Clicks of the same button

May 17th, 2008

Well I have like 3-4 queries done this one submit button so you want me to try doing that for the last one?

But all queries work so the page should be refreshed either way?

Also I have tried Location, and the same thing happens but worse.