Creating an extra spot in DB for status

Hi,

I read somewhere, no idea where that was, that it was possible to add extra information into the table for basically any purpose. I was hoping to use that idea for a contact section on a site, multiple people would be replying to inquiries, so as to avoid multiple replys to a message, we'd set it so that there was a "status" that could be set/changed when it had been responded to. Or better yet record who responded to it (could be manually set).

The form is relatively simple but this storage and "status" issue is really doing my head in. Any suggestions?

Thanks,
Shayne

Hi Shayne,

Add a status column to the table you are using to save the inquiries and set the value to 0

Use a second form to reply to the inquiries (you can include a link to the form in the email you send out). Have that form check the status and if it is still 0 then load the inquiry content, when the form is submitted have it update the status to 1.

Bob

Hey Greyhead,

Thanks for the reply, makes sense. I have a few questions though, my knowledge of coding is still... ongoing. I've added the status field to the table. How do I go about having the form check the status, load the data and edit status? That would take some php coding wouldn't it? not my strongest field. If you talk me through it I'd be grateful.

Thanks in advance,
Shayne