PDA

View Full Version : TINYINT field returning 0 when should be 3


]|V|[agnus
05-05-2005, 05:58 PM
Odd problem I'm trying to solve here... there is a field in this MySQL table called NumPayments, indicating how many payments a customer is to make on an order. The form submitting the order allows for possible values of NumPayments to be 1 or 3. Looking at the database, I see that the appropriate value is being inserted. However, for reasons quite beyond me, when the value is 3, the queries return a value of 0 for that field. When the value is 1, the value seems to be returned as 1, as expected.

I'm quite at a loss on this. Any clues?

Velox Letum
05-05-2005, 11:52 PM
It would be useful if you posted the query and table structure.