Hye I realllly neeed help from someone. This project is due tonite by 11pm.
Ok so I have the following menu created dynamically with SQL:
<?php
$link = mysql_connect("localhost", "username", "pwd");
mysql_select_db ("dbname");
$query = "SELECT DISTINCT PersonChosen FROM TableName";
$query_result_handle = mysql_query ($query);
$num_of_rows = mysql_num_rows($query_result_handle);
?>
<select name="PersonName">
<?php
for ($count = 1; $row = mysql_fetch_row ($query_result_handle); ++$count)
{
echo "
<option value= $row[0]>$row[0]</option>";
}
mysql_close($link);
?>
</select>
So, the PersonChosen has peoples names, e.g. John Doe, Gail Smith, Herb, etc.
When the menu pops up I get the names like John Doe, Gail Smith, and Herb in it..
But my problem is when i echo the name out for example echo "$PersonName"; I only get for example John or Gail and not their last name.
Can some pleeease help me out this is reallly urgent.
Thanks
Rik
