<div>
<div class="content wysiwyg-content">
I currently have a price field set up as INT (11). <br />
<br />
This price field was to show annual salaries &nbsp;ie 35,000, 25,000 etc but now I need to include hourly rates such as 6.19. If you 6.19 at the moment it just shows as 6.<br />
<br />
So I now need to show decimal values can this be done keeping the INT format? or do I need to change the structure?<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2013/01_w01/625070/Screen-Shot-2013-01-02-at-14.56..png" target="_blank" title="db (22 KB)"><img alt="db" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2013/01_w01/800_625070/Screen-Shot-2013-01-02-at-14.56..png" /></a>
</div>
</div>


Screen-Shot-2013-01-02-at-14.56..png

I currently have a price field set up as INT (11). 

This price field was to show annual salaries  ie 35,000, 25,000 etc but now I need to include hourly rates such as 6.19. If you 6.19 at the moment it just shows as 6.

So I now need to show decimal values can this be done keeping the INT format? or do I need to change the structure?



Show decimals with MySQL database

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.