NetHosted Community

Hello,

I've got a php script which will pull data from a mysql database. This works fine but when I try to populate a html input box with the data not all the data is displayed, e.g. for the name: John Smith, will only display John in the textbox (anything after a space is not shown), does anyone know the reason for it doing that?

The code used to ouput the data is simply just (in between php):

<input name=first_name size=20 value=$new1>

Hope someone can help,Cheers,

Mitch

Mitch,

You'll need to put quotes round the variable in the <input> tag. (Escaping if necessary.)

Regards,

Pete

_________________
"I have made this letter long, only because I lacked the time to make it short." - Blaise Pascal 1657

And since you're using PHP, you'll want to escape the quotes, with \ before them:
echo "<input name=\"first_name\" size=\"20\" value=\"$new1\"/>";

Alternatively, you can switch to singles quotes for the PHP bit, and then don't need to scape the HTML quotes:
echo '<input name="first_name" size="20" value="'.$new1.'"/>';

_________________
Peter Boughton

_________________
"I have made this letter long, only because I lacked the time to make it short." - Blaise Pascal 1657