Sak, check out what Aerewen said before about invalid column counts between databases. If you are getting a zero stuffed into Password, maybe that zero was destined for the Status column instead?
Best way to do inserts (on new accounts) is to always provide the (field_names) for every (field_value) you supply.
Eg.,
INSERT INTO account (name, password, status) VALUES ('name','password','status');
Many people tend to take the shortcut, and just do a:
INSERT INTO account VALUES ('name','password','status');
...but that implies **exact** column placement and order. If accounts has 4 columns, for example, the above insert would error with "invalid column count" or something about not being able to find a column. Check that out.
I wish my linux webserver was working. I'm dying to try this out!
|