Dynamic Text Field/MYSQL

[smitty1140]

how do i stop it from truncating?

[kuau]

Dear Smitty: I've been up all night and need to get some sleep now. Have you defined a datatype for the price variable? I'm just learning php so this is a bit beyond me. There are some great people on DD who know infinitely more than I. But I'd look at this and see exactly what it is doing. Good luck! Sorry I can't be of more help.

KT_escapeAttribute($row_rsmenu_items['price']);

[smitty1140]

Still need some help if anyone knows anything?

[maddysanoo]

I believe your query asks us a very important question.
what type is best for price?
Our first instinct might go for a number, but price is in the form XX.XX, so we can not just use any number form, we need it to support decimal places, for `float', `double', `real' and `decimal' we can specify the size and number of decimal places that we want to be able to use so I would suggest one of these is used and due to the limitations of `float' and `double/real' I would suggest using `decimal/numeric' to show our prices, although this field type does actually store the values as a string I believe it is the best for our needs.

I hope this answers your question... Let me know... I experienced this on a recent project i am doing and it very well fulfill my need.