Whenever I add a new record to the database, the last field's input is ignored and my login username is recorded in it's place. The only way to get around this is by modifying the record, and then it works just fine. Can anyone tell me what's wrong? If you want to see for yourself, the address is
http://www.jskaterspage.com/db/db.cgi?db=skateparks
just use regular author/author for login at the moment.

I take that back... it doesn't work with modify. It just keeps the username. Why?

When the content of one field is being displayed in the incorrect field, it is normally because a modification was made to the database configuration without having also made the modification to the actual database.

Example - Your initial config & db with these fields:

field1|field2|field3|field4

Then, a change to the config, such as:

field1
field2
field3
field4
field5
field6

If the actual database has not been modified to reflect the changes, you now have:

field1|field2|field3|field4
field1|field2

Everything works numerically, if you have not created the placeholders for the number of fields now in the config file, your database file is "wrapping" the additional fields.

Hope this helps with the troubleshooting.

~ Karen