I try to put decimal data to do a prepaid system!
In fact, I need to do operations like 25.24/0.15.
I cant do $var(a)=25.4/0.15;
I could see that if I do for example $var(a)=166/100; $var(a)=1 ! ! !
How can I do to have $var(a)=1.66 ?
Thank you
Cordialement,
BERGANZ François
Pensez à l'Environnement, n'imprimez ce mail que si nécessaire.
-----Message d'origine-----
De : users-bounces(a)lists.kamailio.org [mailto:users-bounces@lists.kamailio.org] De la part
de Saúl Ibarra
Envoyé : lundi 1 juin 2009 17:05
Cc : users(a)lists.kamailio.org
Objet : Re: [Kamailio-Users] problems with artihmetics operations & MYSQL
What field type are you trying to put the data in?
On Mon, Jun 1, 2009 at 4:51 PM, BERGANZ François
<francois(a)acropolistelecom.net> wrote:
Hello,
I need to select from a database (for example 25.6546)
And I need to do 25.6546/60.
I think that I have a problem with my MySQL database. I tried to insert the
25.6546 in a decimal(5,5) but I cant insert more than 0.99999 !
Anyone know how to do ?
Thank you
Cordialement,
BERGANZ François
P Pensez à l'Environnement, n'imprimez ce mail que si nécessaire.
_______________________________________________
Kamailio (OpenSER) - Users mailing list
Users(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
--
Saúl -- "Nunca subestimes el ancho de banda de un camión lleno de disketes."
----------------------------------------------------------------
http://www.saghul.net/
_______________________________________________
Kamailio (OpenSER) - Users mailing list
Users(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
http://lists.openser-project.org/cgi-bin/mailman/listinfo/users