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 ??


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

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