PHP & MySQL :- and input text fields -perlexing!!!

[Portfar]

Hi

Could anyone help with this perplexing problem.

When I make a form on typical text fields and try to put values into
those fields from a Mysq query then for some reason the value passed
gets chopped of at the first space.

The form is meant to allow a user to change personal details and so
what I want to do is present a form filled in with the current
details and all a user has to do is write over the ones they want to
change.

BUT....

say a person has a name PAUL JONES... getting this from the DB is no
problem but putting it in the text field it gets chopped up at the
first space so only the word PAUL shows up.


DOES ANYONE KNOW WHY, AND HOW I GET AROUND THIS.


THANKS for any HELP


PF

[eclipsboi]

Are you doing:

<input type=text name=whatever value=<?php echo $whatever_value;?>>

Or are you doing:

<input type="text" name="whatever" value="<?php echo
$whatever_value;?>">

Notice the difference between the two; the first, having no quotes
would mean any value with a space in it would get chopped, as you say.
The latter, having quotes, would display the entire value for
whatever_value, spaces and all.


On Tue, 22 Jun 2004 22:24:26 +0100, Portfar <portfar@hotmail.com>
wrote:

>
>
>Hi
>
>Could anyone help with this perplexing problem.
>
>When I make a form on typical text fields and try to put values into
>those fields from a Mysq query then for some reason the value passed
>gets chopped of at the first space.
>
>The form is meant to allow a user to change personal details and so
>what I want to do is present a form filled in with the current
>details and all a user has to do is write over the ones they want to
>change.
>
>BUT....
>
>say a person has a name PAUL JONES... getting this from the DB is no
>problem but putting it in the text field it gets chopped up at the
>first space so only the word PAUL shows up.
>
>
>DOES ANYONE KNOW WHY, AND HOW I GET AROUND THIS.
>
>
>THANKS for any HELP
>
>
>PF

[entoone]

How big is the field in the database? is it large enough to hold the
information being typed into the field?

is the field set for varchar ? or ??

"Portfar" <portfar@hotmail.com> wrote in message
news:6d8hd0l6eooda1tpj8852nvil7elbif5d9@4ax.com...

>
>
> Hi
>
> Could anyone help with this perplexing problem.
>
> When I make a form on typical text fields and try to put values into
> those fields from a Mysq query then for some reason the value passed
> gets chopped of at the first space.
>
> The form is meant to allow a user to change personal details and so
> what I want to do is present a form filled in with the current
> details and all a user has to do is write over the ones they want to
> change.
>
> BUT....
>
> say a person has a name PAUL JONES... getting this from the DB is no
> problem but putting it in the text field it gets chopped up at the
> first space so only the word PAUL shows up.
>
>
> DOES ANYONE KNOW WHY, AND HOW I GET AROUND THIS.
>
>
> THANKS for any HELP
>
>
> PF

[Portfar]

On Tue, 22 Jun 2004 21:54:54 GMT, eclipsboi <eclipsboi@hotmail.com>
wrote:

>Are you doing:
>
><input type=text name=whatever value=<?php echo $whatever_value;?>>
>
>Or are you doing:
>
><input type="text" name="whatever" value="<?php echo
>$whatever_value;?>">
>
>Notice the difference between the two; the first, having no quotes
>would mean any value with a space in it would get chopped, as you say.
>The latter, having quotes, would display the entire value for
>whatever_value, spaces and all.
>
>

Thanks very much, that seems to have totally got rid of the problem.

Thankyou fro your help, much appreciated.



PF