Textbox Retrieval from DB

[thebigchief]

I have a problem where I am unable to display a DB entry that for exampe says "John Doe".

 

The code I am using is:

 

<tr>
<td>Agent Full Name:</td>
<td><input type="text" name="fullname" value='.$agentdata['fullname'].'></td>
</tr>

 

The output shows "John" instead of "John Doe", have I missed something here 

[the182guy]

Are you sure the field contains John Doe? Post the code that performs the query and subsequent processing.

[thebigchief]

yeah the DB entry is "John Doe"

 

the rest of the stuff is:

 

$agentdata = mysql_fetch_array($user);

$id = $_GET[id];
$user = mysql_query("SELECT * FROM users WHERE id='".$id."'");

 

Its funny though because if I display the echo just as html and not in a textbox it shows the lot using the code:

 

echo "<td".$rowclass.">"; echo $row['fullname']; echo "</td>";

[thebigchief]

Anyone?

 

Surely this is a common problem and Im just being stupid?

[thebigchief]

Fixed it:

 

<tr>

<td>Full Name:</td>

<td><input type="text" name="fullname" value="'.$agentdata['fullname'].'"></td>

</tr>

 

I was missing a " after value= and before ></td>

 

Knew I was mossing something stupid