Form Field Giving Unexpected Result

Anon

Greetings,

I am a newbie writing a mysql database and using php.

The following code is supposed to output names from table 1 in a Last, First Middle format. The output looks exactly as it should, but when you examine the record in table 2, the data stops after Last. What looks like Smith, John Q in the form is stored as Smith

<tdIssued To:</td>
<td><select size="1" name="IssuedTo">
<option value="<?php echo $myrow[IssuedTo] ?>"><?php echo $myrow["IssuedTo"] ?></option>
<option value="Not Issued">Not Issued</option>

Get Shooters From Table

Connect to Table

$sql = "Select LastN, FirstN, MiddleI FROM shooters ORDER BY LastN, FirstN, MiddleI";

$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$nm="$row[LastN] $row[FirstN], $row[MiddleI]";

           echo "<option value=";
           echo $nm;
           echo ">";
           echo $nm;
           echo "</option>";

           }
           ?></select></td>
           <?
           mysql_free_result($result);

           ?>

          </tr>

Sorry this post is so long. Thanks in advance for any help.

Mike

Anon

Further experimentation indicates that it is the space that something - probably the html - doesn't like. If I change it to $nm="LastN,...$FirstN...MiddleI";
it records the entire name.

Any suggestions on how to do the same using spaces?

Thanks,

Mike

thinsoapy

try concatenating...

$nm = "$row[LastN]" . ", " . "$row[FirstN]" . " " . "$row[MiddleI]";

The . won't print, but whatever you put inside the "" will, like " " is a space.

Hope it works.

Dave

mfleck

Dave,

Thanks for trying but I get the same result.

It seems important to point out that the php SEEMS to work - when you view the form the entire name appears, properly formatted. Its just that once you make your selection and save the form, only the last name and the comma get stored in the database.

If you replace the space with any other charachter, it looks odd but the entire name gets saved. I still wonder if it is the html that sees a space and ends the data at the space.

Any other ideas?