[RESOLVED] How to display results for this

MitchEvans

I need to post the results of the drop down boxes to the next page, any ideas how I would do this? There will be more than one set of results so they will need to be in an array of some kind.

	
echo"<FORM method='POST' action='riskassestestpdf.php?id=$id&more=$more'>";
while ($inquiryrow = mysql_fetch_array($results)) {

	$hcode=$inquiryrow["hcode"];
	$hazard=$inquiryrow["hazard"];
	$riskrating=$inquiryrow["riskrating"];
	$riskto=$inquiryrow["riskto"];


echo"
<table border=1>
<tr><td><strong>Code</strong></td><td><strong>Hazard</strong></td><td><strong>Rating</strong></td><td><strong>At Risk</strong></td></tr>
<tr><td>$hcode</td><td>$hazard</td><td>$riskrating</td><td>$riskto</td></tr>
<tr><td></td><td><strong>Change To:</strong></td><td><select name='rate'>
  <option value='High'>High</option>
  <option value='Medium'>Medium</option>
  <option value='Low'>Low</option>
</select></td><td><select name='risk'>
  <option value='Employer'>Employer</option>
  <option value='Employee'>Employee</option>
  <option value='Student'>Student</option>
  <option value='Patient'>Patient</option>
</select></td></tr></table><p>";
}	
echo"<center><INPUT type='submit' name='mybutton' value='Convert To PDF'></center></form>";

MitchEvans

The code below allows me to echo the last result only i need all of the results.

<?
$rate=$_POST['rate'];
$risk=$_POST['risk'];

echo $rate;
echo $risk;
?>

leatherback

Instead of
<select name='rate'>

use e.g.,
<select name='rate[]'>
which will create an array of ratings.

Even better would be to include the IOD of the actual record you are rating:
echo "<select name=\"rate[".rate[$row['ID']."]\">";

Use a [man]foreach[/man] on $_POST['rate'] to show the individual values.

MitchEvans

What would i put in the foreach brackets?
Is thi swhy I need that id?

<?
$rate=$POST['rate'];
$risk=$POST['risk'];

foreach (what goes here ) {
echo $rate;}
echo $risk;
?>

leatherback

You would need the ID to ascertain in the next page that you are inserting the values for the right records. Otherwise you have no control over your dataflow.

The foreach loop is a way to loop to an array and FOR EACH value in the array do something:

$names = array('Joe','Alan','Pete','Chris');

foreach($names as $key => $name)
  {
  echo "I like: ".$key.". ".$name."<br />";
  }

MitchEvans

Thanks for helping really appreciate it!

So I have now set this so that each record has a unique id:

<tr><td></td><td><strong>Change To:</strong></td><td><select name='rate{$inquiryrow['id']}[]'>
  <option name='rate{$inquiryrow['id']}[]' value='High'>High</option>
  <option name='rate{$inquiryrow['id']}[]' value='Medium'>Medium</option>
  <option name='rate{$inquiryrow['id']}[]' value='Low'>Low</option>

So what needs to go on the next page in order to show the unique results?

leatherback

Almost:

// I like to not use {} but use ". as it facilitates debugginh
<option name="rate[".$inquiryrow['id']."]" value='High'>High</option>

In the next page you can use the foreach I showed you:

foreach($_POST['rate'] as $id => $value)
  {
  echo $id." = ".$value."<br />";
  }

MitchEvans

Excellent thats solved tankyou so much!!!!!!!!!!!!!!!!🙂