Writing data from MySql into text fields

[lbabinz]

Hi,

I seem to be having trouble writing data from a mysql query into a text field on a form. If, for instance, the data is an address such as "7149 California Blvd." and I try to write it into a form's text field, it will only write up until the first blank space. It would output simply "7149". Does anyone know a way to get the entire string into the text field? Many thanks in advance.

[Anon]

Can you post the code ?

[Anon]

I had that problem once. Although they are optional, you have to use quotes around your values to get the whole string, otherwise HTML thinks it ends at the first space:

<input type=text name=street value="<?php print $street ?>" size=30>

Of course, then you may have some quote issues, so you should use stripslashes when you grab it from the database:

$street = stripslashes($query_data["street"]);

That should fix it.

[lbabinz]

Right on,

That worked perfectly. I can't believe it was something so basic as to add opposing quotes. Many thanks for the answer, that has been bothering me for waaaaaayyy to long 🙂.