textfields showing only first word of a line

[torva]

Registered: Oct 2004
Location:
Posts: 3

I've got a problem with fetching info from a mysql database, and then putting it in a textfield. If I get the string "John Johnson" this would be presented as "John" in the textfield.
Here is some of my code:

$result = $this->query("SELECT name FROM personTab where personId=23");

$row = mysql_fetch_row($result);

$personName=$row[1];

<table>
<tr>
<td><label>Navn:</label></td>
<td><input type="text" name="personName" value="$personName"></td>
</tr>
</table>

Thanks T.

[devinemke]

what do you see when you just do this:

$result = $this->query('SELECT name FROM personTab WHERE personId = 23');
echo mysql_result($result, 0);

[dnszero]

Most likely your problem is in the data insertion. Are you quoting the values in your SQL query when inserting them?

[torva]

I've got a problem with fetching info from a mysql database, and then putting it in a textfield. If I get the string "John Johnson" this would be presented as "John" in the textfield.
Here is some of my code:

$result = $this->query("SELECT name FROM personTab where personId=23");

$row = mysql_fetch_row($result);

$personName=$row[1];

When I put in this:
echo '$personName';
it would print John Johnsonabove the textfield, so there is nothing wrong with the sql...

$result = $this->query("SELECT name FROM personTab where personId=23");

$row = mysql_fetch_row($result);

$personName=$row[1];

<table>
<tr>
<td><label>Navn:</label></td>
<td><input type="text" name="personName" value="$personName"></td>
</tr>
</table>

Thanks T.

<table>
<tr>
<td><label>Navn:</label></td>
<td><input type="text" name="personName" value="$personName"></td>
</tr>
</table>

Thanks T.

[xblue]

torva, could you please post the code you actually use? sure you can cut it down to the relevant parts, but only so far to leave a working code fragment that still exposes the problem.

[torva]

I found the error. I didn't quote the value I filled in. This is how I did it value=$personName.

And this is how it should be done...
<td><input type="text" name="personName" value="$personName"></td>

[Roger_Ramjet]

Having taken the trouble to come back and post that you've sovled your problem, you might want to mark it as resolve the next time as well. cf link at bottom of page. Just saves us time opening threads that have already been resolved, TIA.

[xblue]

torva -

that is exactly what I suspected, but if the code you post is correct while the code you run is not, it is fairly difficult for people to help you. just something to keep in mind for next times.