Home News Forum Articles
  Welcome back Join CF
You are here You are here: Home | Forum | MySQL and decimal points


You are currently viewing our boards as a guest which gives you limited access to view most of the discussions, articles and other free features. By joining our Virgin Media community you will have full access to all discussions, be able to view and post threads, communicate privately with other members (PM), respond to polls, upload your own images/photos, and access many other special features. Registration is fast, simple and absolutely free so please join our community today.


Welcome to Cable Forum
Go Back   Cable Forum > Computers & IT > General IT Discussion
Reload this Page MySQL and decimal points
Register FAQ Members List Calendar Mark Forums Read

MySQL and decimal points
Reply
 
Thread Tools
Old 02-06-2004, 13:15   #1
Millay
Inactive
 
Millay's Avatar
 
Join Date: Oct 2003
Location: Portsmouth
Age: 35
Posts: 1,689
Millay has reached the bronze age
Millay has reached the bronze ageMillay has reached the bronze ageMillay has reached the bronze ageMillay has reached the bronze ageMillay has reached the bronze ageMillay has reached the bronze ageMillay has reached the bronze age
Send a message via MSN to Millay Send a message via Yahoo to Millay
MySQL and decimal points
Hi all, mySQL has to be told how to work with data ioncluding decimal points ie a money value, at the moment it is just removing anything after the decimal point, I am using MyPHPAdmin to work with the database and table, any pointers would be good

Many thanks
Andy
Millay is offline   Reply With Quote
Advertisement
Old 02-06-2004, 13:24   #2
Richard M
cf.mega poster
 
Join Date: Jun 2003
Location: Los Angeles, CA
Age: 34
Posts: 6,414
Richard M has a bronze arrayRichard M has a bronze arrayRichard M has a bronze array
Richard M has a bronze arrayRichard M has a bronze arrayRichard M has a bronze arrayRichard M has a bronze arrayRichard M has a bronze arrayRichard M has a bronze arrayRichard M has a bronze arrayRichard M has a bronze arrayRichard M has a bronze arrayRichard M has a bronze arrayRichard M has a bronze arrayRichard M has a bronze arrayRichard M has a bronze arrayRichard M has a bronze arrayRichard M has a bronze arrayRichard M has a bronze arrayRichard M has a bronze arrayRichard M has a bronze arrayRichard M has a bronze arrayRichard M has a bronze array
Re: MySQL and decimal points
You need to make sure that the field type is set to "float" rather than int or small int etc.
Richard M is offline   Reply With Quote
Reply

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Google Search




All times are GMT. The time now is 02:56.

Contact Us - Service Status - Virgin.Net Status - Cable Forum - Archive - Privacy Statement - Terms of Service - Top

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2013, vBulletin Solutions, Inc.
Copyright © 2003 - 2012, Cable Forum.
(server5.cableforum.co.uk)
Copyright © 2013 Cable Forum | Hosted On 1&1 Dedicated Server

SEO by vBSEO 3.3.2