[AnnPage]

I'm having a little problem attempting to fill a html input value statement with php variable data.

$row["member_contact_info1"] contains '123 Main Street'

When the form is displayed, I can enter data '123 Main Street', the data is recorded into the database properly, the data is read from the database properly, the data is then displayed as '123' and the remaining characters are truncated.

Why is variable data being truncated after the 1st space? How can I use variable data with the html input value statement?

The example below shows variable data from an array but the result would be the same if I used ---- VALUE = $info1; where $info1='123 Main Street''

Code:

  print ("<tr>");
  print ("<td align=left>");
  print ("&nbsp;&nbsp;<b>Street 1:</b></td><td>");

  print ("<INPUT TYPE=text NAME=member_contact_info1 SIZE=41 MAXLENGTH=100 VALUE=".$row["member_contact_info1"].">");

  print ("</td>");
  print ("</tr>");

[Facundo]

Let's go to the beggining and then start making harder questions.

The easiest one:

Have you already checked that the varchar where you are inserting the street allows you to enter more than 3 characters?

[AnnPage]

Facundo thank you for your reply.
Maybe I didn't explain my problem properly.

The data is being recorded correctly in the database, the data is being extracted correctly from the database. The problem is displaying the data in the form field.
Even thou the variable (info1) contains '123 Main Street' the form field only displays '123' instead of '123 Main Street'.
We can forget the database entirely, if I store data into a variable i.e. $info1='123 Main Street''; and then feed $info1 into the value= statement I still only receive '123' in the form field.

Should the html form value statement correctly display a php variable?

Thanks,
Ann

[job0107]

Originally Posted by AnnPage

I'm having a little problem attempting to fill a html input value statement with php variable data.

$row["member_contact_info1"] contains '123 Main Street'

When the form is displayed, I can enter data '123 Main Street', the data is recorded into the database properly, the data is read from the database properly, the data is then displayed as '123' and the remaining characters are truncated.

Why is variable data being truncated after the 1st space? How can I use variable data with the html input value statement?

The example below shows variable data from an array but the result would be the same if I used ---- VALUE = $info1; where $info1='123 Main Street''

Code:

  print ("<tr>");
  print ("<td align=left>");
  print ("&nbsp;&nbsp;<b>Street 1:</b></td><td>");

  print ("<INPUT TYPE=text NAME=member_contact_info1 SIZE=41 MAXLENGTH=100 VALUE=".$row["member_contact_info1"].">");

  print ("</td>");
  print ("</tr>");

The reason you are having this problem is because the input elements follow strict rules.
When a variable isn't specifically defined as string then the input element will stop displaying the data after the first space.
In order to correct this problem, you have to quote the PHP variable in the input element.

PHP Code:

  print ("<INPUT TYPE=text NAME=member_contact_info1 SIZE=41 MAXLENGTH=100 VALUE='".$row["member_contact_info1"]."'>"); 

[AnnPage]

job0107, I can't begin to thank you enough. I didn't know where the problem was, it took a couple of days just to track it down to this statement. I've learned something I'll never forget and for that I am grateful. I owe you a pizza, Thanks!!

[job0107]

Your welcome. Glad I could help.