Relaxer Posted April 30, 2003 Share Posted April 30, 2003 Hi, im making a small inventory using mysql. In my $price i choose decimal and 10,2 in the length. My interface is made in HTML code. The problem is when i input the price, the data is not shown in the db. all it shows is the default 0.00. Help me please.. Thanks in advance Link to comment https://forums.phpfreaks.com/topic/413-newbie-question/ Share on other sites More sharing options...
barbatruc Posted April 30, 2003 Share Posted April 30, 2003 How do you proceed for your Insert queries ? You should have something like: INSERT INTO `table` (`field`) VALUES (\'5\'); If `field` is a decimal field and has a length of 10,2 this will insert value 5.00 into the database. In MySQL, even if you place values between \', values will be converted to the right format. Also, be sure to use the \".\", not the \",\" to separate the decimal part from the integer part. JP. Link to comment https://forums.phpfreaks.com/topic/413-newbie-question/#findComment-1388 Share on other sites More sharing options...
Relaxer Posted April 30, 2003 Author Share Posted April 30, 2003 Thanks! I\'ll give it a try. Link to comment https://forums.phpfreaks.com/topic/413-newbie-question/#findComment-1400 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.