Hi everyone,
Before I ask for help please be aware that I am not a programmer... just a net admin floundering around! I have a website that I paid a programmer to build for me. Now I'm trying to teach myself MySQL, html and php by fixing and changing things on my site myself by trial and error.
The site is basically a group of pages that query a MySQL database and return search results to the users. There are a couple of php pages that are forms for me to do the database data input. Those are the forms I'm having a problem with.
I've added about 20 fields in the database and have to add those fields to the data input 'additem.php', data edit 'edititem.php' files. What I've been doing is just copy and pasting the code that is already there and modifying it to match the new fields I've added to the database. It's not working. The file displays properly but it will not add or update the actual DB records. I know that the database is ok since the forms work fine if I rollback to the original copies of them without all of my changes.
This is really driving me insane. It doesn't make sense that I can't just copy and paste the lines of code and have it work. There has to be something that I don't understand. Like does the list of fields in the php forms have to be in the same order that the fields are in the database itself?? I don't know what to look for that might be wrong in the files that I've modified.
I'm attaching one of the files for an example. I've shortened it quite a bit. I just took out a ton of the records but left everything else. I also noted where I need to add records.
Can anyone help me out with this?
Thanks!!
cheryl
