I am doing an SQL query and one of the fields is a company name. The field is a VARCHAR and is set to 255 characters. So I do this query and then use the data to populate a form, but only the first word of the company name appears, so if the company is Peter Pan Peanut Butter, all I get is Peter. Where did I go wrong?
<?php
$findsubscriber = "(SELECT company FROM subscriber_data WHERE id = '$id')";
while ($row = mysql_fetch_array($findsubscriber_result)) {
$company = $row["company"];
echo"
<table width=\"448\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" align=\"left\" valign=\"top\">
<tr>
<td width=\"104\" align=\"right\"><div class=\"formlabels\">Company: </div>
</td>
<td width=\"344\" align=\"left\">
<input size=\"40\" name=\"company\" type=\"text\" tabindex=\"1\" value=$company />
</td>
</tr>
</table>
;"
}
?>
