show and update record

ale

Hi all.
i have a problem with thi code. This code show and update a record of my database. When the page is loaded, it show my record. i update the record.(is ok, becouse i can see my database changed in window MSdos with MYSQL). But when i exit from this page and came back (i select this page ofrom another menu) this page not show the record updated (i repeat: the record is updated but the page not show this).

Problem:
The variable $uten not show the data update, but show the old data!!!?????

HELP ME PLEASE!!!!!

<?php session_start(); 
$idses=session_id();
require_once('Connections/iscritticon.php');
.
.
.

$editFormAction =$HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
  $editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}


mysql_select_db($database_iscritticon, $iscritticon);
//mysql_free_result($Result0);
$datiSQL = sprintf("SELECT * FROM info WHERE info.nickname = %s  ;", GetSQLValueString($HTTP_SESSION_VARS["snickname"], "text"));
$uten=NULL;
$Result0 = mysql_query($datiSQL, $iscritticon) or die(mysql_error());
$uten = mysql_fetch_array($Result0);

if ((isset($HTTP_POST_VARS["MM_insert2"])) && ($HTTP_POST_VARS["MM_insert2"] == "form9")) 
{ 

  $insertSQL = sprintf("UPDATE info SET nickname= %s , nameboat = %s ,password= %s , country= %s, nambmainsail = %s ,email = %s WHERE info.nickname= %s ",
                       GetSQLValueString($HTTP_POST_VARS['nicknamet'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['nomebarcat'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['passwordt'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Nazionet'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['numerorandat'], "int"),
                       GetSQLValueString($HTTP_POST_VARS['emailt'], "text"),
 			           GetSQLValueString($HTTP_SESSION_VARS["snickname"], "text"));
   mysql_select_db($database_iscritticon, $iscritticon);
  $datiSQL = sprintf("SELECT * FROM info WHERE info.nickname = %s  ;", GetSQLValueString($HTTP_SESSION_VARS["snickname"], "text"));
  $uten=NULL;
  $Result0 = mysql_query($datiSQL, $iscritticon) or die(mysql_error());
  $uten = mysql_fetch_array($Result0);

  $Result1 = mysql_query($insertSQL, $iscritticon) or die(mysql_error());
	        $insertGoTo = "PageItaModDatiok.php";
             if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) 
               {
                  $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
                  $insertGoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
               }

          header(sprintf("Location: %s&PHPSESSID=%s", $insertGoTo,$idses));

   //}
}

 $datiSQL = sprintf("SELECT * FROM info WHERE info.nickname = %s  ;", GetSQLValueString($HTTP_SESSION_VARS["snickname"], "text"));
$uten=NULL;
$Result0 = mysql_query($datiSQL, $iscritticon) or die(mysql_error());
$uten = mysql_fetch_array($Result0);
if (isset($uten)) 
     {  unset($uten);
	    $Result0 = mysql_query($datiSQL, $iscritticon) or die(mysql_error());
        $uten =mysql_fetch_array($Result0);

 }
echo $HTTP_SERVER_VARS['PHP_SELF'];
echo $HTTP_SERVER_VARS['QUERY_STRING'];
echo isset($uten);

?>

<html>
.
.
.

<form action="

<?php   echo $editFormAction;?>

" method="POST" enctype="application/x-www-form-urlencoded" name="form9" target="_top" onSubmit=......>
.
.
.
.

    <td width="54%"> <input name="nicknamet" type="text" id="nicknamet" value="[code=php]<?php echo $uten["nickname"]; ?>[/code]"  size="20" maxlength="20"> 
    </td>
  </tr>
  <tr> 
    <td><div align="right">&nbsp;&nbsp;Nome Barca :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div></td>
    <td> <input name="nomebarcat" type="text" id="nomebarcat" value="[code=php]<?php echo $uten["nameboat"]; ?>[/code]" size="20" maxlength="20"> 
    </td>
  </tr>
  <tr> 
    <td><div align="right">&nbsp;&nbsp;Password :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div></td>
    <td> <input name="passwordt" type="password" id="passwordt" value="[code=php]<?php echo $uten["password"]; ?>[/code]"  size="20" maxlength="10"> 
    </td>

.
.
.

<div align="center"> <br>
  <span class="menudestra"> 
  <input name="inviat" type="submit" id="inviat" value="Invia">
  <br>
  <input type="hidden" name="MM_insert2" value="form9">
  </span> </div>

</form>
.
.
</body>
</html>

ale

.... this page not show the record update, but the old information
help
thank all

ale

UP UP (help me!!!)

xblue

hi, okay you are new here and may not know, but:

"bumping" is disliked by most people, see
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10218925

and you might get more answers if you
a) wrap your code in [php] [/php] tags, this enables the syntax highlighting (you can always edit your post)
b) cutting down the code to the smallest size that still exposed the problem is a good idea two.

ale

Thank xblue for that you tell me .
Is it ok now?

jowatkins

OK, I can't quite see what's wrong with your code, as xblue said, it's not so easy to read as posted. But this is the method I use.

if ($result)  //check query worked
{ 
  echo mysql_affected_rows($result)."  Record Updated."; //let user know update worked
  echo "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"3;URL=page_url.php?search_criteria=$searchdata\"></a>";	
  //refresh page back to original url and send through the information the script needs to search on to find the updated record
}

xblue

okay, you are sure that it isn't a caching problem?

then, you seem to reuse a lot of variables like $uten in different parts of your code. insert some echo (or printf for arrays)statements to make sure they hold what you think they do.

ale

hi xblue and jowatkins

Thank.

I tell you this.
I tried to insert a scrpt that print the time. The page print , fist time, time exatly.After , when i reload the page, it print same time( the time not chage)!!!!???
But the local server is ok , becuse if i use the script (time) in page empty, it print time exatly and whan i reload the page , it sow the time exatly!!!???