Need Help!

phpBEN

I need to retrieve results from a mysql database into the HTML drop down select box. I have done so with the following code and it works fine:

                          <select name="semamount">
                            <? do {  ?>
                            <option value="<?php echo $row_sql['semprice'];?>"><?php echo $row_sql['semname'];?></option>
                            <?
								 } while ($row_sql = mysql_fetch_assoc($sql));
  									$rows = mysql_num_rows($sql);
  										if($rows > 0) {
      									mysql_data_seek($sql, 0);
       									$row_sql = mysql_fetch_assoc($sql);
  								}
				?>
                          </select>

My problem is that as you can see from the code, the value is grabbed from a row named "semprice" and the display name is grabbed from a row named "semname". I would pass such variables to another php page that would capture the semprice and do a calculation but I dont know how to capture the select "semname". How would I also capture this part (semname) depending on which the user selected before being directed to the processing form.

If someone can help me, I would really appreate it, I have been struggling with this problem for a while now and I just can't figure out how to capture the "semname".

Thanks!

Roger_Ramjet

you could do it by including BOTH in the value string


value="<?php echo $row_sql['semprice'] . ',' . $row_sql['semname'];?>">

this would return the 2 as a comma seperated list, eg <option value="10.99,widget">, that your target script can process.

PS watch out for commas in the price eg 1,750.00 may want to use something else as the seperator.

phpBEN

Hi Roger,

thanks for your help, how exactly would I retrieve the values? I tried retreiving the values by

echo "<b>Seminar:</b> ".$semname." <br>";

and nothing shows up.

Thanks

Roger_Ramjet

several ways but I'd probably use this


// data is in the $_POST array and your server should have register_globals OFF

// explode it into an array
$sem = explode(',' , $_POST['semamount']);
// use semname
echo "<b>Seminar:</b> ".$sem[1]." <br>";

phpBEN

Thanks so much Roger, it worked!