Jump to content


Photo

*SOLVED* php myadmin question


  • Please log in to reply
1 reply to this topic

#1 xtiancjs

xtiancjs
  • Members
  • PipPipPip
  • Advanced Member
  • 47 posts

Posted 02 April 2006 - 10:15 PM

Hi all, I have a field in my table that requires a default value of 2.5,
The field is a basic int field, in phpmy admin when I put the default value at 2.5, upon save it automatically rounds down to a 2, can anybody help me with this. I'm sure I am missing something obvious
xtian

#2 toplay

toplay
  • Staff Alumni
  • Advanced Member
  • 973 posts

Posted 02 April 2006 - 11:38 PM

An integer type holds whole numbers (i.e. 1, 15, 30, 100, etc.). You have to change the type to hold a floating point number (float/decimal). See:

[a href=\"http://dev.mysql.com/doc/refman/4.1/en/numeric-type-overview.html\" target=\"_blank\"]http://dev.mysql.com/doc/refman/4.1/en/num...e-overview.html[/a]






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users