data retrival

[dbomb101]

I have created a page php page which retrieves data from a sql database so that the user can edit the details, once the user sumbits the changes to the database (by pressing the html submit button) the page refreshes and displays the message i created but the original data remains only when the page is refreshed a second time it changes. is there any way i can fix this ?

how i retrieve the info

require('query.php');
$details="select * from tutordetails WHERE p_id='".$_SESSION['id']."'";
$result=getQuery($details,$l);
while($row = mysql_fetch_array($result))
  {
	$forename=$row['forename'];
	$surname=$row['surname'];
	$postcode=$row['postcode'];
	$telephone=$row['telephone'];
	$hideemail=$row['hideemail'];
	$aboutme=$row['aboutme'];
  }

here is how it is submited to a update query in another page

require('EditPage.php');
if(isset($_POST['button']))
{
if($forename==mysql_escape_string($_POST['forename']) && $surname==mysql_escape_string($_POST['surname']) && $postcode==mysql_escape_string($_POST['postcode']) && $telephone == mysql_escape_string($_POST['telephone']) && $aboutme == mysql_escape_string($_POST['aboutme']))
{
$message= "";
}
else if(edit($errormsg))
{
$message= "<h3>You have successfully edited your details</h3>";
}
else $message=$errormsg;
}

here is how i display the info

<span class="editInfo" id="forenameSpan">Forname:</span><input type="text" name="forename" id="forename" value="<?php echo $forename ?>" />

[rincewind456]

Use $_SESSION variables for the SQL output, that way they'll persist across the session.

[dbomb101]

I tried using session variables to no avail, once the submit button is pressed it outputs the correct message but still has the previous data

<?php 
session_start();
require('query.php');
$details="select * from tutordetails WHERE p_id='".$_SESSION['id']."'";
$result=getQuery($details,$l);
while($row = mysql_fetch_array($result))
  {
	$_SESSION['forename']=$row['forename'];
	$_SESSION['surname']=$row['surname'];
	$_SESSION['postcode']=$row['postcode'];
	$_SESSION['telephone']=$row['telephone'];
	$_SESSION['hideemail']=$row['hideemail'];
	$_SESSION['aboutme']=$row['aboutme'];
  }
?>

[rincewind456]

I'm a little confused, do you want to persist the variable or not?

Run this snippet

<?php
session_start();


$name = "fred";
$_SESSION['name'] = $name;

echo "name Variable = ".$name;
echo "<br>Session name variable = ".$_SESSION['name'];
unset($_SESSION['name']);
echo "<br>Session name variable = ".$_SESSION['name'];
unset($name);
echo "<br>name Variable = ".$name;
?>

and you should get output like

name Variable = fred
Session name variable = fred
Session name variable =
name Variable = 

So if you don't want a variable to persist use [man]unset()[/man].

[dbomb101]

ok here is the problem i retreive some information from my sql database e.g the name Dragon

require('query.php');
$details="select * from tutordetails WHERE p_id='".$_SESSION['id']."'";
$result=getQuery($details,$l);
while($row = mysql_fetch_array($result))
  {
	$forename=$row['forename'];
   }

Dragon is presented into the input box

<span class="editInfo" id="forenameSpan">Forname:</span><input type="text" name="forename" id="forename" value="<?php echo $forename; ?>" />

the user changes the name from Dragon to Darren and presses the submit button to send it over to the insert function i created

the function sends back a confirmation that Darren has been saved
and to make sure that the information is different i get it to do a compar the posted name with the one saved on the database

if($forename==mysql_escape_string($_POST['forename']))
{
$message= "";
}
else if(edit($errormsg))
{
$message= "<h3>You have successfully edited your details</h3>";
}
else $message=$errormsg;
}

the problem is that the Dragon is there instead of Darren once the user presses the submit button, but Dragon shows up once the page is refreshed again e.g the user clicking the page link again