[RESOLVED] Solving page expired problem

[Tezread]

I know how to do this but im getting it wrong somehow. Basically I have a basic form and a formhandler. Trouble is if a submit the the form and output the resultsthen go to another page, then click the back button I get the good old message

"The page you requested was created using information you submitted in a form. This page is no longer available. As a security precaution, Internet Explorer does not automatically resubmit your information for you."

Now I know a way around this is to use $_GET instead of POST but I want to do it another way where Instead of posting the data from page1.php to page2.php, post it to an intermediary page called 'page1-exec'.php

page1-exec.php should not output anything to the browser. After data processing is over, you simply use the header() function to redirect to page2.php

Instead of posting the data from page1.php to page2.php, post it to page1-exec.php

page1-exec.php should not output anything to the browser. After data processing is over, simply use the header() function to redirect to page2.php
I get this but ive tried it with no luck- im not sure how to cut/paste what code where to the new intermediary page.
here is my original formhandler;

<?php
include("connect.php");
if(isset($_POST['submit'])) 
{ 
$username = $_SESSION['username']; 
foreach($_POST['activity_checkbox'] as $value) 
        { 
		$sql = 'INSERT INTO supportactivityuser (`username`, `supportactivity_id`) VALUES ("'.$username.'", "'.$value.'")'; 
        $result = mysql_query($sql, $connection) or die(mysql_error()); 
		//execute your query 


    } 
} 
else 
//no activity selected 
{

echo '<br/>No activities selected'; 
} 
?>
<?php
if(isset($_POST['submit'])) 
{ 
$username = $_SESSION['username']; 
foreach($_POST['expert_checkbox'] as $value) 
        { 
		$sql = 'INSERT INTO expertuser (`username`, `expert_id`) VALUES ("'.$username.'", "'.$value.'")'; 
        $result = mysql_query($sql, $connection) or die(mysql_error()); 
		//execute your query 


    } 
} 
else 
//no areas of expertise selected selected 
{

echo '<br/>No areas of expertise selected'; 
} 
?>
<strong>Welcome</strong><br> 
                    <?php echo $_SESSION['username'];?>
<?php
if(isset($_POST['submit']))  {

$sql = "SELECT supportactivity.supportactivity_id AS supportactivity_id, supportactivity.supportactivity AS supportactivity, 
supportactivityuser.username AS username, qualityadmin.quality_name AS quality_name, 
qualityadmin.qualityadmin_id AS qualiyadmin_id
FROM supportactivity 
LEFT JOIN supportactivityrelations ON supportactivity.supportactivity_id = supportactivityrelations.supportactivity_id 
LEFT JOIN supportactivityuser ON supportactivity.supportactivity_id = supportactivityuser.supportactivity_id 
LEFT JOIN qualityadmin ON supportactivityrelations.quality_name = qualityadmin.quality_name 
WHERE supportactivityuser.username = '$username'";

$results = mysql_query($sql); 
while ($row = mysql_fetch_array ($results)){ 
$name = $row["quality_name"];
echo '<a href="info_details.php?quality_name='. urlencode($row[3]) .'">'. $row[3] .'</a><br><br>';  

$sql_support_activity = "SELECT supportactivity.supportactivity_id AS supportactivity_id, supportactivity.supportactivity AS supportactivity, 
qualityadmin.quality_name AS quality_name, qualityadmin.qualityadmin_id AS qualiyadmin_id
FROM supportactivity 
LEFT JOIN supportactivityrelations ON supportactivity.supportactivity_id = supportactivityrelations.supportactivity_id 
LEFT JOIN supportactivityuser ON supportactivity.supportactivity_id = supportactivityuser.supportactivity_id 
LEFT JOIN qualityadmin ON supportactivityrelations.quality_name = qualityadmin.quality_name 
WHERE supportactivityrelations.quality_name = '$name'";
$set2 = mysql_query($sql_support_activity);
//process each support activity
while ($row = mysql_fetch_array ($set2)){ 
$name3 = $row["supportactivity"];
echo  "<br>$name3";


}

}
?>
	<?php
	if(isset($_POST['submit']))  {

$sql2 = "SELECT expert.expert_id AS expert_id, expert.expert AS expert, 
expertuser.username AS username, qualityadmin.quality_name AS quality_name,
qualityadmin.qualityadmin_id AS qualiyadmin_id
FROM expert 
LEFT JOIN expertrelations ON expert.expert_id = expertrelations.expert_id 
LEFT JOIN expertuser ON expert.expert_id = expertuser.expert_id 
LEFT JOIN qualityadmin ON expertrelations.quality_name = qualityadmin.quality_name 
WHERE expertuser.username = '$username'";

$results2 = mysql_query($sql2); 
while ($row2 = mysql_fetch_array ($results2)){ 
$name2 = $row2["quality_name"];
echo  "<br><strong>$name2</strong>";
//echo '<a href="' . $row['search_url'] . '">$name</a>';

$sql_expert = "SELECT expert.expert_id AS expert_id, expert.expert AS expert, 
qualityadmin.quality_name AS quality_name, qualityadmin.qualityadmin_id AS qualiyadmin_id
FROM expert 
LEFT JOIN expertrelations ON expert.expert_id = expertrelations.expert_id 
LEFT JOIN expertuser ON expert.expert_id = expertuser.expert_id 
LEFT JOIN qualityadmin ON expertrelations.quality_name = qualityadmin.quality_name 
WHERE expertrelations.quality_name = '$name'";
$set3 = mysql_query($sql_expert);
//process each support activity
while ($row = mysql_fetch_array ($set3)){ 
$name4 = $row["expert"];
echo  "<br>$name4";


}

}

}
}
?>

couls someone poiunt out what code should go where?

thanks in anticipation

[esukf]

The following should get you started (code not tested but you should get the general idea).
I'm assuming all the code in page2.php are just display the results since I haven't really looked into it.

page1-exec.php

<?php

if(isset($_POST['submit'])){
	include("connect.php");
  //array to hold form errors	
  $form_error = array();

  //validate your form data

  if(!isset($_POST['activity_checkbox'])){
  	$form_error[] = "No activities selected";
  }

  if(!isset($_POST['expert_checkbox'])){
  	$form_error[] = "No areas of expertise selected";	
  }	

  if(count($form_error) > 0){
  	//hold the error in session so you can display the error in your form page.
  	$_SESSION['form_error'] = $form_error;

//redirect to the form
header("Location: http://www.yoursite.com/page1.php");	
  } else {
  	//do your data processing

$username = $_SESSION['username'];
foreach($_POST['activity_checkbox'] as $value){
	$sql = 'INSERT INTO supportactivityuser (`username`, `supportactivity_id`) VALUES ("'.$username.'", "'.$value.'")';
	$result = mysql_query($sql, $connection) or die(mysql_error());
	//execute your query
}

foreach($_POST['expert_checkbox'] as $value){
	$sql = 'INSERT INTO expertuser (`username`, `expert_id`) VALUES ("'.$username.'", "'.$value.'")';
	$result = mysql_query($sql, $connection) or die(mysql_error());
	//execute your query
}

//remove the form_error session
unset($_SESSION['form_error'])
//redirect to result display page
header("Location: http://www.yoursite.com/page2.php");	
}
}	 
?>

page2.php

<strong>Welcome</strong><br>
<?php 
//display results

echo $_SESSION['username'];

$username = $_SESSION['username']; 

$sql = "SELECT supportactivity.supportactivity_id AS supportactivity_id, supportactivity.supportactivity AS supportactivity,
supportactivityuser.username AS username, qualityadmin.quality_name AS quality_name,
qualityadmin.qualityadmin_id AS qualiyadmin_id
FROM supportactivity
LEFT JOIN supportactivityrelations ON supportactivity.supportactivity_id = supportactivityrelations.supportactivity_id
LEFT JOIN supportactivityuser ON supportactivity.supportactivity_id = supportactivityuser.supportactivity_id
LEFT JOIN qualityadmin ON supportactivityrelations.quality_name = qualityadmin.quality_name
WHERE supportactivityuser.username = '$username'";

$results = mysql_query($sql);
while ($row = mysql_fetch_array ($results)){
$name = $row["quality_name"];
echo '<a href="info_details.php?quality_name='. urlencode($row[3]) .'">'. $row[3] .'</a><br><br>';  

$sql_support_activity = "SELECT supportactivity.supportactivity_id AS supportactivity_id, supportactivity.supportactivity AS supportactivity,
qualityadmin.quality_name AS quality_name, qualityadmin.qualityadmin_id AS qualiyadmin_id
FROM supportactivity
LEFT JOIN supportactivityrelations ON supportactivity.supportactivity_id = supportactivityrelations.supportactivity_id
LEFT JOIN supportactivityuser ON supportactivity.supportactivity_id = supportactivityuser.supportactivity_id
LEFT JOIN qualityadmin ON supportactivityrelations.quality_name = qualityadmin.quality_name
WHERE supportactivityrelations.quality_name = '$name'";
$set2 = mysql_query($sql_support_activity);
//process each support activity
while ($row = mysql_fetch_array ($set2)){
$name3 = $row["supportactivity"];
echo  "<br>$name3";


}

}


$sql2 = "SELECT expert.expert_id AS expert_id, expert.expert AS expert,
expertuser.username AS username, qualityadmin.quality_name AS quality_name,
qualityadmin.qualityadmin_id AS qualiyadmin_id
FROM expert
LEFT JOIN expertrelations ON expert.expert_id = expertrelations.expert_id
LEFT JOIN expertuser ON expert.expert_id = expertuser.expert_id
LEFT JOIN qualityadmin ON expertrelations.quality_name = qualityadmin.quality_name
WHERE expertuser.username = '$username'";

$results2 = mysql_query($sql2);
while ($row2 = mysql_fetch_array ($results2)){
$name2 = $row2["quality_name"];
echo  "<br><strong>$name2</strong>";
//echo '<a href="' . $row['search_url'] . '">$name</a>';

$sql_expert = "SELECT expert.expert_id AS expert_id, expert.expert AS expert,
qualityadmin.quality_name AS quality_name, qualityadmin.qualityadmin_id AS qualiyadmin_id
FROM expert
LEFT JOIN expertrelations ON expert.expert_id = expertrelations.expert_id
LEFT JOIN expertuser ON expert.expert_id = expertuser.expert_id
LEFT JOIN qualityadmin ON expertrelations.quality_name = qualityadmin.quality_name
WHERE expertrelations.quality_name = '$name'";
$set3 = mysql_query($sql_expert);
//process each support activity
while ($row = mysql_fetch_array ($set3)){
$name4 = $row["expert"];
echo  "<br>$name4";

}
}
?>

[Tezread]

Thankyou - not sure why but im getting an error message:

Parse error: parse error, unexpected T_STRING, expecting ';'

this is where:

 //remove the form_error session 
      unset($_SESSION['form_error']) 
      //redirect to result display page 
      header("Location: http://www.mindseyemidlands.co.uk/notts_quality/info_resource/sourcesofhelp_page2.php");     

    } 
}

[ClarkF1]

unset($_SESSION['form_error'])

Missing the ; on this line

[Tezread]

Strange- I see what you mean there. Now my form is not navigating to part 2- it just stays on part 1 when i click submit

part1.php

///at top of page before html output
<?php
include("include/session.php");
?>

<?php
following code in middle of html
  echo '<strong>Welcome</strong><br>';
  ?>
					<?php echo $_SESSION['username'];?>
            <?php
	include ("connect.php");


// Get the areas of expertise 
$sql_expert = "SELECT * FROM expert ORDER by expert"; 
$expert_result = mysql_query($sql_expert) or die("Error fetching areas expertise: ".mysql_error()); 
$expert_array = mysql_fetch_assoc($expert_result); 

// Get the activities 
$sql_activity = "SELECT * FROM supportactivity ORDER by supportactivity"; 
$activity_result = mysql_query($sql_activity) or die("Error fetching activities: ".mysql_error()); 
$activity_array = mysql_fetch_assoc($activity_result); 
?>

        <?php

  echo '<form name="searchform" method="POST" action="sourcesofhelp_intermediary.php">'; 
echo '
<table> 
<tr> 
<td>Select the support activities:</td> 
</tr> 
<tr> 
<td>'; 
while ($row = mysql_fetch_assoc($activity_result)) { 
//foreach($activity_array as $activity){ 
echo '<input type="checkbox" name="activity_checkbox[]" value="'.$row['supportactivity_id'].'">'.$row['supportactivity'].'';
} 

echo ('</td> 
</tr> 
<tr> 
<td>Select the areas of areas of expertise:</td> 
</tr> 
<tr> 
<td>'); 

while ($row = mysql_fetch_assoc($expert_result)) { 
//foreach($activity_array as $activity){ 
echo '<input type="checkbox" name="expert_checkbox[]" value="'.$row['expert_id'].'">'.$row['expert'].'';
} 

echo ('</td> 
</tr>
<tr> 
<td>Select the quality systems:</td> 
</tr> 
<tr> 
<td>'); 


echo ('</td> 
</tr>
<tr> 
<td> 
  <input type="submit" name="submit" value="Search"> 
</td> 
</tr> 
</table>'); 

echo '</form>';
	  ?>   

intermediary.php (put this before html output as i was gettign headers already sent error message

<?php
include("include/session.php");
?>
<?php 

if(isset($_POST['submit'])){ 
    include("connect.php"); 
  //array to hold form errors     

  $form_error = array(); 

page2.php (in middle of mtml ouptut
[code=php]
<?php 
//display results 

echo $_SESSION['username']; 

$username = $_SESSION['username']; 

$sql = "SELECT supportactivity.supportactivity_id AS supportactivity_id, supportactivity.supportactivity AS supportactivity, 
supportactivityuser.username AS username, qualityadmin.quality_name AS quality_name, 
qualityadmin.qualityadmin_id AS qualiyadmin_id 
FROM supportactivity 
LEFT JOIN supportactivityrelations ON supportactivity.supportactivity_id = supportactivityrelations.supportactivity_id 
LEFT JOIN supportactivityuser ON supportactivity.supportactivity_id = supportactivityuser.supportactivity_id 
LEFT JOIN qualityadmin ON supportactivityrelations.quality_name = qualityadmin.quality_name 
WHERE supportactivityuser.username = '$username'"; 

$results = mysql_query($sql); 
while ($row = mysql_fetch_array ($results)){ 
$name = $row["quality_name"]; 
echo '<a href="info_details.php?quality_name='. urlencode($row[3]) .'">'. $row[3] .'</a><br><br>';   

$sql_support_activity = "SELECT supportactivity.supportactivity_id AS supportactivity_id, supportactivity.supportactivity AS supportactivity, 
qualityadmin.quality_name AS quality_name, qualityadmin.qualityadmin_id AS qualiyadmin_id 
FROM supportactivity 
LEFT JOIN supportactivityrelations ON supportactivity.supportactivity_id = supportactivityrelations.supportactivity_id 
LEFT JOIN supportactivityuser ON supportactivity.supportactivity_id = supportactivityuser.supportactivity_id 
LEFT JOIN qualityadmin ON supportactivityrelations.quality_name = qualityadmin.quality_name 
WHERE supportactivityrelations.quality_name = '$name'"; 
$set2 = mysql_query($sql_support_activity); 
//process each support activity 
while ($row = mysql_fetch_array ($set2)){ 
$name3 = $row["supportactivity"]; 
echo  "<br>$name3"; 


} 

} 


$sql2 = "SELECT expert.expert_id AS expert_id, expert.expert AS expert, 
expertuser.username AS username, qualityadmin.quality_name AS quality_name, 
qualityadmin.qualityadmin_id AS qualiyadmin_id 
FROM expert 
LEFT JOIN expertrelations ON expert.expert_id = expertrelations.expert_id 
LEFT JOIN expertuser ON expert.expert_id = expertuser.expert_id 
LEFT JOIN qualityadmin ON expertrelations.quality_name = qualityadmin.quality_name 
WHERE expertuser.username = '$username'"; 

$results2 = mysql_query($sql2); 
while ($row2 = mysql_fetch_array ($results2)){ 
$name2 = $row2["quality_name"]; 
echo  "<br><strong>$name2</strong>"; 
//echo '<a href="' . $row['search_url'] . '">$name</a>'; 

$sql_expert = "SELECT expert.expert_id AS expert_id, expert.expert AS expert, 
qualityadmin.quality_name AS quality_name, qualityadmin.qualityadmin_id AS qualiyadmin_id 
FROM expert 
LEFT JOIN expertrelations ON expert.expert_id = expertrelations.expert_id 
LEFT JOIN expertuser ON expert.expert_id = expertuser.expert_id 
LEFT JOIN qualityadmin ON expertrelations.quality_name = qualityadmin.quality_name 
WHERE expertrelations.quality_name = '$name'"; 
$set3 = mysql_query($sql_expert); 
//process each support activity 
while ($row = mysql_fetch_array ($set3)){ 
$name4 = $row["expert"]; 
echo  "<br>$name4"; 

} 
} 
?> 


  //validate your form data 

  if(!isset($_POST['activity_checkbox'])){ 
      $form_error[] = "No activities selected"; 
  } 

  if(!isset($_POST['expert_checkbox'])){ 
      $form_error[] = "No areas of expertise selected";     

  }     

  if(count($form_error) > 0){ 
      //hold the error in session so you can display the error in your form page. 
      $_SESSION['form_error'] = $form_error; 

  //redirect to the form 
  header("Location: http://www.mindseyemidlands.co.uk/notts_quality/info_resource/sourcesofhelp_page1.php");     

    }  else { 
      //do your data processing 

  $username = $_SESSION['username']; 
  foreach($_POST['activity_checkbox'] as $value){ 
      $sql = 'INSERT INTO supportactivityuser (`username`, `supportactivity_id`) VALUES ("'.$username.'", "'.$value.'")'; 
    $result = mysql_query($sql, $connection) or die(mysql_error()); 
    //execute your query 
  } 

  foreach($_POST['expert_checkbox'] as $value){ 
      $sql = 'INSERT INTO expertuser (`username`, `expert_id`) VALUES ("'.$username.'", "'.$value.'")'; 
    $result = mysql_query($sql, $connection) or die(mysql_error()); 
      //execute your query 
  } 

  //remove the form_error session 
  unset($_SESSION['form_error']);
  //redirect to result display page 
  header("Location: http://www.mindseyemidlands.co.uk/notts_quality/info_resource/sourcesofhelp_page2.php");     
} 
}     

?>

[esukf]

Can't make sense of what you posted. Is the code in intermediary.php suppose to be sourcesofhelp_intermediary.php (the action of the form)?? Shouldn't the validation part of the code be part of the intermediary page rather than at the bottom of the display page which it what it looks like from your code above.

[Tezread]

You are right- the validation part belongs to the intermediary page. I have edited my previous post so you can now see what I have at present. At present when you submit on page1.php it goes nowhere.

[esukf]

Shouldn't your pages structure look more like this??

sourcesofhelp_page1.php

///at top of page before html output
<?php
include("include/session.php");
?>

<?php
following code in middle of html
  echo '<strong>Welcome</strong><br>';
  ?>
                    <?php echo $_SESSION['username'];?>
            <?php
    include ("connect.php");


// Get the areas of expertise
$sql_expert = "SELECT * FROM expert ORDER by expert";
$expert_result = mysql_query($sql_expert) or die("Error fetching areas expertise: ".mysql_error());
$expert_array = mysql_fetch_assoc($expert_result);

// Get the activities
$sql_activity = "SELECT * FROM supportactivity ORDER by supportactivity";
$activity_result = mysql_query($sql_activity) or die("Error fetching activities: ".mysql_error());
$activity_array = mysql_fetch_assoc($activity_result);
?>

        <?php

  echo '<form name="searchform" method="POST" action="sourcesofhelp_intermediary.php">';
echo '
<table>
<tr>
<td>Select the support activities:</td>
</tr>
<tr>
<td>';
while ($row = mysql_fetch_assoc($activity_result)) {
//foreach($activity_array as $activity){
echo '<input type="checkbox" name="activity_checkbox[]" value="'.$row['supportactivity_id'].'">'.$row['supportactivity'].'';
}

echo ('</td>
</tr>
<tr>
<td>Select the areas of areas of expertise:</td>
</tr>
<tr>
<td>');

while ($row = mysql_fetch_assoc($expert_result)) {
//foreach($activity_array as $activity){
echo '<input type="checkbox" name="expert_checkbox[]" value="'.$row['expert_id'].'">'.$row['expert'].'';
}

echo ('</td>
</tr>
<tr>
<td>Select the quality systems:</td>
</tr>
<tr>
<td>');


echo ('</td>
</tr>
<tr>
<td>
  <input type="submit" name="submit" value="Search">
</td>
</tr>
</table>');

echo '</form>';
      ?> 

sourcesofhelp_intermediary.php

<?php
include("include/session.php");
?>
<?php

if(isset($_POST['submit'])){
    include("connect.php");
  //array to hold form errors     

  $form_error = array();
//validate your form data

  if(!isset($_POST['activity_checkbox'])){
      $form_error[] = "No activities selected";
  }

  if(!isset($_POST['expert_checkbox'])){
      $form_error[] = "No areas of expertise selected";     

  }     

  if(count($form_error) > 0){
      //hold the error in session so you can display the error in your form page.
      $_SESSION['form_error'] = $form_error;

  //redirect to the form
  header("Location: http://www.mindseyemidlands.co.uk/notts_quality/info_resource/sourcesofhelp_page1.php");     

    }  else {
      //do your data processing

  $username = $_SESSION['username'];
  foreach($_POST['activity_checkbox'] as $value){
      $sql = 'INSERT INTO supportactivityuser (`username`, `supportactivity_id`) VALUES ("'.$username.'", "'.$value.'")';
    $result = mysql_query($sql, $connection) or die(mysql_error());
    //execute your query
  }

  foreach($_POST['expert_checkbox'] as $value){
      $sql = 'INSERT INTO expertuser (`username`, `expert_id`) VALUES ("'.$username.'", "'.$value.'")';
    $result = mysql_query($sql, $connection) or die(mysql_error());
      //execute your query
  }

  //remove the form_error session
  unset($_SESSION['form_error']);
  //redirect to result display page
  header("Location: http://www.mindseyemidlands.co.uk/notts_quality/info_resource/sourcesofhelp_page2.php");     
}
}     

?>

sourcesofhelp_page2

<?php
//display results

echo $_SESSION['username'];

$username = $_SESSION['username'];

$sql = "SELECT supportactivity.supportactivity_id AS supportactivity_id, supportactivity.supportactivity AS supportactivity,
supportactivityuser.username AS username, qualityadmin.quality_name AS quality_name,
qualityadmin.qualityadmin_id AS qualiyadmin_id
FROM supportactivity
LEFT JOIN supportactivityrelations ON supportactivity.supportactivity_id = supportactivityrelations.supportactivity_id
LEFT JOIN supportactivityuser ON supportactivity.supportactivity_id = supportactivityuser.supportactivity_id
LEFT JOIN qualityadmin ON supportactivityrelations.quality_name = qualityadmin.quality_name
WHERE supportactivityuser.username = '$username'";

$results = mysql_query($sql);
while ($row = mysql_fetch_array ($results)){
$name = $row["quality_name"];
echo '<a href="info_details.php?quality_name='. urlencode($row[3]) .'">'. $row[3] .'</a><br><br>';   

$sql_support_activity = "SELECT supportactivity.supportactivity_id AS supportactivity_id, supportactivity.supportactivity AS supportactivity,
qualityadmin.quality_name AS quality_name, qualityadmin.qualityadmin_id AS qualiyadmin_id
FROM supportactivity
LEFT JOIN supportactivityrelations ON supportactivity.supportactivity_id = supportactivityrelations.supportactivity_id
LEFT JOIN supportactivityuser ON supportactivity.supportactivity_id = supportactivityuser.supportactivity_id
LEFT JOIN qualityadmin ON supportactivityrelations.quality_name = qualityadmin.quality_name
WHERE supportactivityrelations.quality_name = '$name'";
$set2 = mysql_query($sql_support_activity);
//process each support activity
while ($row = mysql_fetch_array ($set2)){
$name3 = $row["supportactivity"];
echo  "<br>$name3";


}

}


$sql2 = "SELECT expert.expert_id AS expert_id, expert.expert AS expert,
expertuser.username AS username, qualityadmin.quality_name AS quality_name,
qualityadmin.qualityadmin_id AS qualiyadmin_id
FROM expert
LEFT JOIN expertrelations ON expert.expert_id = expertrelations.expert_id
LEFT JOIN expertuser ON expert.expert_id = expertuser.expert_id
LEFT JOIN qualityadmin ON expertrelations.quality_name = qualityadmin.quality_name
WHERE expertuser.username = '$username'";

$results2 = mysql_query($sql2);
while ($row2 = mysql_fetch_array ($results2)){
$name2 = $row2["quality_name"];
echo  "<br><strong>$name2</strong>";
//echo '<a href="' . $row['search_url'] . '">$name</a>';

$sql_expert = "SELECT expert.expert_id AS expert_id, expert.expert AS expert,
qualityadmin.quality_name AS quality_name, qualityadmin.qualityadmin_id AS qualiyadmin_id
FROM expert
LEFT JOIN expertrelations ON expert.expert_id = expertrelations.expert_id
LEFT JOIN expertuser ON expert.expert_id = expertuser.expert_id
LEFT JOIN qualityadmin ON expertrelations.quality_name = qualityadmin.quality_name
WHERE expertrelations.quality_name = '$name'";
$set3 = mysql_query($sql_expert);
//process each support activity
while ($row = mysql_fetch_array ($set3)){
$name4 = $row["expert"];
echo  "<br>$name4";

}
}
?>

It appears you are getting redirected back to the form page cause it's not passing the validation. Add the following in the form page and see if you getting any errors.

<?php

//if validate errors exists, list them out
if(count($_SESSION['form_error']) > 0){  		
	echo '<ul>';
	foreach($_SESSION['form_error'] as $error){
  	echo '<li>'.$error.'</li>';
 	}
 	echo '</ul>';
}
?>

[Tezread]

i have done what you have suggested but i now get this error:

Warning: Cannot modify header information - headers already sent by (output started at /disk1/home3/mindseye/public_html/notts_quality/info_resource/sourcesofhelp_intermediary.php:4) in /disk1/home3/mindseye/public_html/notts_quality/info_resource/sourcesofhelp_intermediary.php on line 25

my code is set out just as you say above so i don't know why this is happening

[Tezread]

bump

[Tezread]

Im still getting the error message 'headers already sent' on line 26/45 in sourcesofhelp_intermediary.php help!!!!!

here are my pages:

sourcesofhelp_page1.php (this displays the form)

<?php
include("include/session.php");
?>

HTML output to browser begins here 
		  <?php 
    include ("connect.php"); 


// Get the areas of expertise 
$sql_expert = "SELECT * FROM expert ORDER by expert"; 
$expert_result = mysql_query($sql_expert) or die("Error fetching areas expertise: ".mysql_error()); 
$expert_array = mysql_fetch_assoc($expert_result); 

// Get the activities 
$sql_activity = "SELECT * FROM supportactivity ORDER by supportactivity"; 
$activity_result = mysql_query($sql_activity) or die("Error fetching activities: ".mysql_error()); 
$activity_array = mysql_fetch_assoc($activity_result); 
?>             

 <?php 

  echo '<form name="searchform" method="POST" action="sourcesofhelp_intermediary.php">'; 
echo ' 
<table> 
<tr> 
<td>Select the support activities:</td> 
</tr> 
<tr> 
<td>'; 
while ($row = mysql_fetch_assoc($activity_result)) { 
//foreach($activity_array as $activity){ 
echo '<input type="checkbox" name="activity_checkbox[]" value="'.$row['supportactivity_id'].'">'.$row['supportactivity'].''; 
} 

echo ('</td> 
</tr> 
<tr> 
<td>Select the areas of areas of expertise:</td> 
</tr> 
<tr> 
<td>'); 

while ($row = mysql_fetch_assoc($expert_result)) { 
//foreach($activity_array as $activity){ 
echo '<input type="checkbox" name="expert_checkbox[]" value="'.$row['expert_id'].'">'.$row['expert'].''; 
} 

echo ('</td> 
</tr> 
<tr> 
<td>Select the quality systems:</td> 
</tr> 
<tr> 
<td>'); 


echo ('</td> 
</tr> 
<tr> 
<td> 
  <input type="submit" name="submit" value="Search"> 
</td> 
</tr> 
</table>'); 

echo '</form>'; 
      ?>
  &nbsp;         </td>
        </tr>
        <tr>
          <td height="97">&nbsp;</td>
        </tr>
      </table>

sourcesofhelp_intermediary.php

<?php
include("include/session.php");
?>

<?php 

if(isset($_POST['submit'])){ 
    include("connect.php"); 
  //array to hold form errors      

  $form_error = array(); 
//validate your form data 

  if(!isset($_POST['activity_checkbox'])){ 
      $form_error[] = "No activities selected"; 
  } 

  if(!isset($_POST['expert_checkbox'])){ 
      $form_error[] = "No areas of expertise selected";      

  }      

  if(count($form_error) > 0){ 
      //hold the error in session so you can display the error in your form page. 
      $_SESSION['form_error'] = $form_error; 

  //redirect to the form 
  header("Location: http://www.mindseyemidlands.co.uk/notts_quality/info_resource/sourcesofhelp_page1.php");      

    }  else { 
      //do your data processing 

  $username = $_SESSION['username']; 
  foreach($_POST['activity_checkbox'] as $value){ 
      $sql = 'INSERT INTO supportactivityuser (`username`, `supportactivity_id`) VALUES ("'.$username.'", "'.$value.'")'; 
    $result = mysql_query($sql, $connection) or die(mysql_error()); 
    //execute your query 
  } 

  foreach($_POST['expert_checkbox'] as $value){ 
      $sql = 'INSERT INTO expertuser (`username`, `expert_id`) VALUES ("'.$username.'", "'.$value.'")'; 
    $result = mysql_query($sql, $connection) or die(mysql_error()); 
      //execute your query 
  } 

  //remove the form_error session 
  unset($_SESSION['form_error']); 
  //redirect to result display page 
  header("Location: http://www.mindseyemidlands.co.uk/notts_quality/info_resource/sourcesofhelp_page2.php");      
} 
}      

?> 

sourcesofhelp_page2.php (displays results)

<?php
include("include/session.php");
?>
HTML output begins here
<?php
//display results 

echo $_SESSION['username']; 

$username = $_SESSION['username']; 

$sql = "SELECT supportactivity.supportactivity_id AS supportactivity_id, supportactivity.supportactivity AS supportactivity, 
supportactivityuser.username AS username, qualityadmin.quality_name AS quality_name, 
qualityadmin.qualityadmin_id AS qualityadmin_id 
FROM supportactivity 
LEFT JOIN supportactivityrelations ON supportactivity.supportactivity_id = supportactivityrelations.supportactivity_id 
LEFT JOIN supportactivityuser ON supportactivity.supportactivity_id = supportactivityuser.supportactivity_id 
LEFT JOIN qualityadmin ON supportactivityrelations.quality_name = qualityadmin.quality_name 
WHERE supportactivityuser.username = '$username'"; 

$results = mysql_query($sql); 
$sql_support_activity = "SELECT supportactivity.supportactivity_id AS supportactivity_id, supportactivity.supportactivity AS supportactivity, 
qualityadmin.quality_name AS quality_name, qualityadmin.qualityadmin_id AS qualityadmin_id 
FROM supportactivity 
LEFT JOIN supportactivityrelations ON supportactivity.supportactivity_id = supportactivityrelations.supportactivity_id 
LEFT JOIN supportactivityuser ON supportactivity.supportactivity_id = supportactivityuser.supportactivity_id 
LEFT JOIN qualityadmin ON supportactivityrelations.quality_name = qualityadmin.quality_name 
WHERE supportactivityrelations.quality_name = '$name'"; 
$set2 = mysql_query($sql_support_activity); 

$sql2 = "SELECT expert.expert_id AS expert_id, expert.expert AS expert, 
expertuser.username AS username, qualityadmin.quality_name AS quality_name, 
qualityadmin.qualityadmin_id AS qualiyadmin_id 
FROM expert 
LEFT JOIN expertrelations ON expert.expert_id = expertrelations.expert_id 
LEFT JOIN expertuser ON expert.expert_id = expertuser.expert_id 
LEFT JOIN qualityadmin ON expertrelations.quality_name = qualityadmin.quality_name 
WHERE expertuser.username = '$username'"; 

$results2 = mysql_query($sql2); 
$sql_expert = "SELECT expert.expert_id AS expert_id, expert.expert AS expert, 
qualityadmin.quality_name AS quality_name, qualityadmin.qualityadmin_id AS qualiyadmin_id 
FROM expert 
LEFT JOIN expertrelations ON expert.expert_id = expertrelations.expert_id 
LEFT JOIN expertuser ON expert.expert_id = expertuser.expert_id 
LEFT JOIN qualityadmin ON expertrelations.quality_name = qualityadmin.quality_name 
WHERE expertrelations.quality_name = '$name'"; 
$set3 = mysql_query($sql_expert); 


while ($row = mysql_fetch_array ($results)){ 
$name = $row["quality_name"]; 
echo '<a href="info_details.php?quality_name='. urlencode($row[3]) .'">'. $row[3] .'</a><br><br>';   

while ($row = mysql_fetch_array ($set2)){ 
$name3 = $row["supportactivity"]; 
echo  "<br>$name3"; 

} 

} 

while ($row2 = mysql_fetch_array ($results2)){ 
$name2 = $row2["quality_name"]; 
echo  "<br><strong>$name2</strong>"; 

while ($row = mysql_fetch_array ($set3)){ 
$name4 = $row["expert"]; 
echo  "<br>$name4"; 

} 
} 
?>  

&nbsp;</td>
        </tr>
        <tr>
          <td height="82">&nbsp;</td>
        </tr>
      </table>
    <!-- InstanceEndEditable --></td>
  </tr>
  <tr>
    <td height="452">&nbsp;</td>
    <td width="699">&nbsp;</td>
  </tr>
</table>
<div align="left"><map name="Map">
    <area shape="rect" coords="20,127,118,152" href="index.php">
    <area shape="rect" coords="440,123,598,154" href="site_map.php">
    <area shape="rect" coords="634,125,748,153" href="search.php">
  </map>
  <!-- link for free use -->
  <script type="text/javascript">
/*************************************************************************
    This code is from Dynamic Web Coding at dyn-web.com
    Copyright 2004-5 by Sharon Paine 
    See Terms of Use at www.dyn-web.com/bus/terms.html
    regarding conditions under which you may use this code.
    This notice must be retained in the code as is!
*************************************************************************/

// setDefaults arguments: size unit, default size, minimum, maximum
// optional array of elements or selectors to apply these defaults to
//dw_fontSizerDX.setDefaults("px", 14, 9, 32, ['div#content'] );

// set arguments: default size, minimum, maximum
// array of elements or selectors to apply these settings to
//dw_fontSizerDX.set(12, 9, 18, ['div.sidebar'] );

dw_fontSizerDX.init();
  </script>
  <script type="text/javascript">
		Element.cleanWhitespace('content');
		init();
	</script>
</div>
</body>
<!-- InstanceEnd --></html>

[Tezread]

esukf wrote:

It appears you are getting redirected back to the form page cause it's not passing the validation. Add the following in the form page and see if you getting any errors.

<?php

//if validate errors exists, list them out
if(count($_SESSION['form_error']) > 0){  		
	echo '<ul>';
	foreach($_SESSION['form_error'] as $error){
  	echo '<li>'.$error.'</li>';
 	}
 	echo '</ul>';
}
?>

Ii i put this debug script on sourcesofhelp_page1.php. i do i get an message saying no activties/areas of expertise selected (if i dont choose activities/areas of exp)

[esukf]

<?php
include("include/session.php");
/*
?>  <- seems you have spaces here which will output to the browser

<?php
*/
if(isset($_POST['submit'])){
    include("connect.php");
  //array to hold form errors      

  $form_error = array();
//validate your form data

  if(!isset($_POST['activity_checkbox'])){
      $form_error[] = "No activities selected";
  }

  if(!isset($_POST['expert_checkbox'])){
      $form_error[] = "No areas of expertise selected";      

  }      

  if(count($form_error) > 0){
      //hold the error in session so you can display the error in your form page.
      $_SESSION['form_error'] = $form_error;

  //redirect to the form
  header("Location: http://www.mindseyemidlands.co.uk/notts_quality/info_resource/sourcesofhelp_page1.php");      

    }  else {
      //do your data processing

  $username = $_SESSION['username'];
  foreach($_POST['activity_checkbox'] as $value){
      $sql = 'INSERT INTO supportactivityuser (`username`, `supportactivity_id`) VALUES ("'.$username.'", "'.$value.'")';
    $result = mysql_query($sql, $connection) or die(mysql_error());
    //execute your query
  }

  foreach($_POST['expert_checkbox'] as $value){
      $sql = 'INSERT INTO expertuser (`username`, `expert_id`) VALUES ("'.$username.'", "'.$value.'")';
    $result = mysql_query($sql, $connection) or die(mysql_error());
      //execute your query
  }

  //remove the form_error session
  unset($_SESSION['form_error']);
  //redirect to result display page
  header("Location: http://www.mindseyemidlands.co.uk/notts_quality/info_resource/sourcesofhelp_page2.php");      
}
}      

?> 

Can you post the exact error you get, the sourcesofhelp_intermediary.php you posted has 47 lines but you're saying it has 45?

[Tezread]

Warning: Cannot modify header information - headers already sent by (output started at /disk1/home3/mindseye/public_html/notts_quality/info_resource/sourcesofhelp_intermediary.php:5) in /disk1/home3/mindseye/public_html/notts_quality/info_resource/sourcesofhelp_intermediary.php on line 26

[esukf]

Remove the following from line 4-6 should sort out the header problem.

?>

<?php

[Tezread]

this seems to be working ok now. could you explain why it made a difference so I know for nesxt time- (and for the benefit of others ofcourse)

[esukf]

Read the manual on the header function.

<?php
?>
           <- blank line sent!
<?php
	header("Location: test.php");
?>

[Tezread]

many thanks esukf!!