[SOLVED] My script won't save the entire input

[kevincro]

My PHP script is not saving the entire value in MySQL.  I'm not sure if the problem is in my script or in my database setup, which is why I posted this in both forums.  I apologize for the double post.  Basically what's going on is, I passed some variables from one page and on to my form page.  When I submit the new form, the data is saved in the database up until the first space.  Everything after the first space is lost.  I'm not sure what I've done wrong.

thanks in advance for any help with this matter.

kevincro

[jd2007]

can i see the sql table setup code and the php code ?

[kevincro]

This is one of my inputs on the form page.  Everything is displayed perfectly on this page.

<TR>
<TD width=110><B>Name:</B></TD>
<TD><INPUT   type=hidden  style="WIDTH: 180px" name=Name
value=<?PHP  echo $row['Name'] ?> </TD><?PHP echo $row['Name']?> </TR>

 

I created the MySQL table manually, but each column in the table is varchar(255), latin1_swedish_ci collation, and each is set to null.

[Barand]

Get into the habit of quoting attribute values.

 

In particular, value="<?PHP  echo $row['Name'] ?>"

 

BTW, you haven't close out that input tag - missing ">"

[Barand]

Don't double post. I have deleted your post of this topic from the MySQL forum

[kevincro]

Putting that in quotes fixed the problem.  Thanks a lot, and again I'm sorry for the double post.