Fields Database in HTML Forms

nhwaldron

I have a nice little page working just fine except some information isn't displaying properly in my HTML form.

For example, I have a "name" field in my database but only the first name shows up in my HTML form.

Any ideas?

Here is a little "snippet" from my code:

                      echo"<FORM ACTION='updatebio.php?bio_id=$myeditrow[id]' METHOD='POST'>";
                        echo"<TABLE BORDER='0' CELLPADDING='0' CELLSPACING='0'>";
                                        echo"<TD>";
                                        echo"Name:<BR><INPUT SIZE='20' NAME='name' VALUE=$myeditrow[name]>";
                                        echo"</TD>";
                                        echo"<TD VALIGN='TOP' ROWSPAN='2'>";
                                                echo"<IMG SRC='../images/$myeditrow[img]' WIDTH='75'>";
                                        echo"</TD>";

Any help is GREATLY appreciated!

jburfield

Try changing:
echo"Name:<BR><INPUT SIZE='20' NAME='name' VALUE=$myeditrow[name]>";

To this:

echo "Name:<BR><INPUT SIZE=\"20\" NAME=\"name\" VALUE=\"" . $myeditrow[name] . "\">";

See if that helps you out.

-- Jason

bastien

and as name is a reserved word for html, you might want to consider changing it to something else

nhwaldron

no such luck...this is driving me crazy!

I am having the trouble with all fields that have more than one word in them (name, title, etc.).

It appears to be a problem w/ HTML forms...

thanks for your input!

jburfield

Do any of the items you are populating the fields with have quotes (") in them? If so, that would mess it up.

Try something like this:

$value = htmlspecialchars($var);

Then in the form element use $value to fill in the value. That will change the quotes (") into html form. " in this example.

-- Jason

nhwaldron

None of the fields have quotes. Just spaces. Only the first word will display...

Just an oddity I never thought I would encounter...

Vex

Try...

echo "Name:<BR><INPUT SIZE='20' NAME='name' VALUE='".$myeditrow[name]."'>";

The value you pass to VALUE must be enclosed in quotes (single or double) if it's anything other than a number...