Icy Phoenix

     
 


Post new topic  Reply to topic 
Page 1 of 1
 
 
Reply with quote Download Post
Post Need Help With Mysql DB 
 
Hi all.

I´ve one Problem.

How to make that myspql accepts half points???

I´ll try to ecplain a bit better. I´m using webtip Mod and since theres been one race with half points, i´m now trying to correct the points manualy in DB.

That goes fine to the time i´ve got to put 3,5 points or anything else with a comma.

mysql just puts the next bigger number there.

so i put 3,5 and DB says 4.

How can i change that ??


EDIT

solved the problem myself changing the table to floating . now it works like i need it .

I used this code in PhpMyAdmin

Code: [Download] [Hide]
  1. ALTER TABLE `ip_formel_wm` CHANGE `wm_points` `wm_points` FLOAT( 8 ) UNSIGNED NOT NULL DEFAULT '0'; 


You only need to change the points manualy in PhpMyAdmin

Table ip_wm_points

Id of the rainrace with halfpoints 2
 




____________
Out of Order
 
spydieSend private messageVisit poster's website  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Post new topic  Reply to topic  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events


  

 

  cron