Problem with database update script?

windflame

Hello everyone,

I'm hoping someone can help me ASAP. Heres the problem, i had a script written for me that managed orders and stuff like that, part of the script was a section to change prices. so i went there an hour or so ago and tried to change the prices, and when i pressed "go" everything reset to 9.99. So then i started to get a little nervious and when i checked the database it reflected 9.99. So in a last hope i tried to edit the 9.99 price through phpmyadmin and even when i tried to save it in there it reflected the 9.99 price! What is causing this to happen!?

I am willing to pay $5 to anyone that can help me fix this. more if it takes a long time but it seems like its just a setting on one thing.

email me: mark at panicbuttonsinc dot com
aim me: mastervampa
yahoo me: mastervampa
msn me: mark at panicbuttonsinc dot com

im on everything in hope that someone will help!

THANKS,
mark

nemonoman

I would expect that the person who created your database set the type of that field as DECIMAL (3,2)

Means the maximum a decimal number having 3 digits of which 2 digits are decimal digits.

The largest number that this format can accomodate is 9.99

It's my guess that you tried to update the field to a number greater than 9.99. MySQL truncates the input value to the largest value the column can accomodate: 9.99.

Using phpMyAdmin, ALTER the STRUCTURE of that column to a size that accomodates a larger firnat number.

Example Pulldown the DECIMAL type, enter 5,2.,
Largest value this format can accomodate is 999.99