[RESOLVED] General Question

[blckspder]

I have this whole system I built for managing trouble tickets... I was testing the form earlier... and now all of the sudden the forms do not work properly... somethings no longer get databased that had no problem getting databased before... the only thing I changed was adding a field to the main table that has information inserted into it when someone submits a trouble ticket.. the field is no longer used after that and is really just there for reporting purposes.. why would some things just stop databasing? is it because I added that record? or are there glitches with MySQL or something where those things just happen?

[Installer]

What's the name and type of the new field? Do you get an error message? What is "get databased" exactly?

[blckspder]

the new field is called timeStamp and it doesnt give any errors, im using left joins and populating about 4 tables with different information... however in the one of the tables the resolution description will no longer populate... Ill just have to do some extensive de bugging... but i was just wondering if there was some flaw or instability in mysql that could cause that.

[tomhath]

MySQL is very stable and reliable, something else must've changed.

Are you referencing columns by subscripts (e.g. "SELECT * FROM ...", then in php "if row==1) ...")? A new column would throw everything off.

I've never heard "databased" and "databasing" used as verbs. Interesting.

[blckspder]

really? they are used as verbs alot here in upstate ny... i think i picked it up from some of my professors. thanks for the help... your very right about adding a column.. it threw everything off.. thanks again