passing data back to html forms

tc61380

Hi,

I am trying to repopulate an HTML form with data I pull from a database so the user can update and edit the information. However, the data is cut off at the first space, meaning if a string has 2 words, only the first word will be seen.

So for example, if I have "Super men" for my UnionName field, and try to populate a textbox with it, only "Super" will show up. ("Super men" will show up correctly if not in a text box though.)

Am I doing something wrong here? Much help appreciated, thanks greatly in advance.

here is my code

Edit Unions
<form action="editunion.php" method="post" name="edit">
<table border="1">
<tr>
<td></tD>
<td>Union Name</td>
<td>Union Location</td>

</tr>

<?php
include 'odbc.php';
$query = odbc_exec($odbc, "SELECT * FROM Unions") or die (odbc_errormsg());
$i = 0;
while($row = odbc_fetch_array($query))
{
echo "<tr>";
echo "<td><input type=checkbox name=" . "UnionKey[]" . " value=" . $row['UnionKey'] . "></td>";
echo "<td><input type=textbox name=" . "UnionName[]" . " value=" . (string)$row['UnionName'] . "></td> ";
echo "<td><input type=textbox name=" . "UnionLocation[]" . " value=" . (string)$row['UnionLocation'] . "></td>";

$i ++;
echo "</tr>";
}
odbc_close($odbc);

</table>

SpanKie

Try adding single quotes or \" in your form field options

Example:

echo "<td><input type=checkbox name='" . "UnionKey[]" . "' value='" . $row['UnionKey'] . "'></td>"; 
echo "<td><input type=textbox name=\"" . "UnionName[]" . "\" value=\"" . (string)$row['UnionName'] . "\"></td> ";

See if that helps ya out ...

tc61380

bling bling!!!! thank you so much!

(btw what is the reason for needing the quotes in a form?)

SpanKie

The single or double quote is for the HTML output ... so your option is surrounded by either or.

Hope that makes sense ... view your page and select view source to look at the HTML for the form fields, you should spot what I mean.