One of my variables is empty ...

[dotty]

I have a form where the field values are variables from a recordset. One of the fields is a option list which gets its value from another recordset, based on id from the first recordset. The option values appear on the page but are not passing to the next page like the other form fields are.

I know there is something about temporary variables - where you need to read the temp variable and turn them into ordinary variables but I don't know how to do this.

Does anyone know how?? 🙁

[planetsim]

What is the code you are currently using? As your using a form are you using $_POST?

[dotty]

Here is my code: - and I am using POST

//get list of products
$query = "SELECT productname,desc,featurenum,price FROM products WHERE catid = '$_GET[catid]'";
//now I am getting the product features to populate the list menu
$query_rsfeatures = "SELECT featurenum,featurename,featureprice FROM features";

//this displays the products
while ($row = mysql_fetch_array($results)) {
     extract ($row);
     echo "<td valign='top'>";
     echo "<a href = 'getprod.php?prodid=" . $prodnum ."'>";
     echo "<img src='images/".$prodimage."'</td></a>";
     echo "<div align='left'><a href = 'getprod.php?prodid=" . $prodnum ."'>View more &raquo;</a>&nbsp;&nbsp;</div>";
	 echo"<td valign='middle'>";
     echo "<a href = 'getprod.php?prodid=" . $prodnum ."'>";
     echo $name ."</a><br><br>".$desc_short;
     echo "<br>";
	 //show product options if they exist
	  if ($featurenum > 0) {
	echo "<br>Options:<br><select name='prodfeature'>";
      while ($row_rsfeatures = mysql_fetch_array($rsfeatures))

{
 echo "  <option name='prodfeature' value=" . $row_rsfeatures['featureprice'] . ">" . $row_rsfeatures['featurename'] . "+" . $row_rsfeatures['featureprice']
    . "</option>\n";
}
	}
	 echo "</select><br></td>";
    echo"<td valign='bottom'>";
     echo "<a href='getprod.php?prodid=" . $prodnum ."'>";
     echo "€" . $price;
echo "<br><br></td>";
	 echo "<td valign='bottom'>";

 echo"</a><form method='POST' action='add.php'> Quantity:";
 echo"<input type='text' name='qty' size='2' value='1'>";
 echo"<input type='hidden' name='prodnum' value=".$prodnum.">";
 echo"<input type='submit' name='Submit' value='Add to cart'>";
 echo"</form>";
 echo"<form method = 'POST' action='cart.php?prodid=".$prodnum .">";
 echo"<input type='submit' name='Submit' value='View cart'>";
 echo"</form></td></tr>";
 }

the form submits to a page:

$qty =$_POST['qty']; //this is okay
$prodnum = $_POST['prodnum']; //this is okay
$prodfeatures = $_POST['prodfeature']; //this is empty!!

[planetsim]

From that I cant even see a field that has that name.

[dotty]

Hi Planetsim,

The select field is called 'prodfeature' and this is the one that is populated from the second recordset

[planetsim]

Ok heh I must have missed it. Anyway it doesnt appear to be inbetween form tags. Also there is no attribute called name for option

[dotty]

eek: omigod - the form tag!

I just put the name attribute in there to see if it would work some kind of miracle :o :

[dotty]

Hi Planetsim

Thanks for your help - I might never have noticed that I'd put the form opening tag after the select menu! Doh!

Hope I didn't waste your time! 🙂