this is a dumb question i am sure but i am new with mysql and am having problems.
both problems have to do with sending form data to a script and inserting the data to the database. the first problem is this:
i have a table with a DATE datatype. when i send a date from a form input to the database i receive no errors but when i retrieve the entry it shows as: 0000-00-00
when i insert a date from the mysql command line it works fine.
the second problem is i have a table that holds an invoice number in an VARCHAR datatype. the invoice number has numbers and letters. if i enter just numbers it is fine. if i enter numbers and letters or just letters it does not insert the value and i get no error messages. and like the first, if i do it manually it works.
any help on this would be great.
chris
both problems have to do with sending form data to a script and inserting the data to the database. the first problem is this:
i have a table with a DATE datatype. when i send a date from a form input to the database i receive no errors but when i retrieve the entry it shows as: 0000-00-00
when i insert a date from the mysql command line it works fine.
the second problem is i have a table that holds an invoice number in an VARCHAR datatype. the invoice number has numbers and letters. if i enter just numbers it is fine. if i enter numbers and letters or just letters it does not insert the value and i get no error messages. and like the first, if i do it manually it works.
any help on this would be great.
chris