php - mysql echo does not retrieve word after a space in textbox

Question

I have a textbox which i echo data from mysql. However if there is a space in the mysql database feild it does not show the word after the space. For example. If there was 'Joe Bloggs' in the database and I echoed it to the text field it would only show 'Joe'. Confused as to why.

PHP:

textbox:

 <input name="name" title="Enter Name" size="23" maxlength="250" value=<?php echo $row['name']?>>

Answer 1

Try putting your value in quotes:

<input name="name" type="text" id="name" title="Enter Name" size="23" maxlength="400" value="<?php echo htmlspecialchars($row3['name'])?>">