I have a field in a MySql database formatted as a Decimal 6,2 which holds the amount of money a person has paid towards an invoice.
When my PHP ipn [I'm using paypal as my payment processor] script reads the amount paid field of the database, the value that is returned is 459.54 when it should be 9.99 for this particular test.
I don't understand this... I've run the query against the database directly and 9.99 is returned, as expected. What could possibly be the issue?
Also, I'm not doing any formatting against the number that is returned, what I echo to my debug text file is the value of the variable of what is being returned from the database.
When my PHP ipn [I'm using paypal as my payment processor] script reads the amount paid field of the database, the value that is returned is 459.54 when it should be 9.99 for this particular test.
I don't understand this... I've run the query against the database directly and 9.99 is returned, as expected. What could possibly be the issue?
Also, I'm not doing any formatting against the number that is returned, what I echo to my debug text file is the value of the variable of what is being returned from the database.
