Drop Down Menu Data

NZ_Kiwis

Hi,

I have this drop down code...

<form method="POST" action="http://www./clubs.php">

      <p> 

<select name="clubs"  size="1" style="font-family: Verdana; font-size: 8pt">
<option value"http://www../"></b>
<font face="Verdana" size="2"> -- Select --</option>
<?php
mysql_connect (localhost, , );
mysql_select_db ();
$result3 = mysql_query ("SELECT * From results_club where area_id = 'Manawatu'");
while ($row3 = mysql_fetch_array($result3)) {
?>
<option value"<?php echo $row3["club_id"]; ?>"></b><font face="Verdana" size="2"><?php echo $row3["club_name"]; ?></option>
<?php
}
?>
</select>
          </p>
<input type="submit" value="Submit" name="B1" style="font-family: Verdana; font-size: 8pt; border-style: solid; border-width: 1px">
          </form>

Now I want to use the the club_id
this code

$area2 = $_GET['clubs'];
echo $area2;

on the next page gets the name not the idea... why??? and how do I fix this?

nemonoman

Please post the finished code returned by your script to the user...specifically show the HTML that builds the select dropdown.

My guess that you need to add space:
option value"<?php echo $row3["club_id"]; ?>"></

and make it option value "<?php echo $row3["club_id"]; ?>"></

I think if you look at the returned code, it will say
<option value"xxx">
and PHP returns the value, not the value" of the select. If there is no value (and if I'm right about this typo, there isn't), then PHP returns the Label of the select...which is what you are GETting.

NZ_Kiwis

It was the = sign

Thanks

PS: this is only part of my code