populating form fields with database fields

leistico

Hi there

Frustrating problem I hope someone might be able to help me with...

I'm setting up a php/mysql site with two sites, admin and user. On the admin side, I'm setting up three types of functions: Add record, delete record and change record. I've got Add and Delete licked, my problem comes with the change record.

The way I'm handling it is that there are 11 fields per record and I'm reading the data from the current record then putting the fields into text fields, text areas, drop-down lists, etc on the change page, just like the same interface used for adding a record, except populating the fields with the current data.

My problem is: when I read data from the database and try to put it in a text field, all I get is the first word from the database field into the text fields on the html form (i.e. anything up to the first blank space stored in the database field). The fields are TEXTVAR's and I read them in with mysql_fetch_array, then have a ?php echo $whatever ? in the "value" field for the "text" input type.

...hope that made sense...

What am I doing wrong that makes it read/print only the first word of what's in the database field into the "value" field?

Any help would be appreciated

siwis

Take at look at your output html source code.

I'd imagine that your value= is not bounded with double quotes ie value="value"
That would cause the field contents top ditch at the first space character.

leistico

That's exactly what it was! "Duh" on my part...

Here's what I ended up with, that finally worked, in case anyone else ever has the same problem...

<p>Title <input type="text" name="edfictitle" value="<?php echo "$fictitle" ?>" ></p>

...where $fictitle is what I read the value in as from the database from the mysql_fetch_array() . The quotes used here might look a bit redundant, but that's what it took to make it work. Also, note no semicolon after the php statement--took that out since it's my understanding that a single-line single-command statement doesn't require one.

Thanks again!

system

Originally posted by siwis
Take at look at your output html source code.

I'd imagine that your value= is not bounded with double quotes ie value="value"
That would cause the field contents top ditch at the first space character.

thx for this info...
although it's 'old', it's very usefull, I've been searching for a hour so...

thx siwis