Reputation: 2 Apprentice
- Active Members
- Active Posts:
- 223 (0.28 per day)
- 02-October 11
- Profile Views:
- Last Active:
- Jun 15 2013 05:49 AM
- Dream Kudos:
Posts I've Made
Posted 1 Jun 2013I have fixed this by using 8,5
Posted 1 Jun 2013Ok so i am storing users earnings that they have made in side my database i have the column set has decimal(5,5) It seems has soon has the vale hits 0.99999 it will not go any higher example over to 1.00000 i am doing a simple update
$fdfsdfdsfsdf = mysql_query("UPDATE users SET available_earning=available_earning+0.00002 WHERE id = '".$owner2."'") or die(mysql_error());
The update works in till the earnings get up to 0.99999 then stops. Any idea's what i can do ?
Posted 25 May 2013It might be something like
UPDATE `user_pokemon` SET `name` = REPLACE(`name`, 'shiny', '') WHERE `name` LIKE CONVERT( _utf8 '%shiny%' USING latin1 ) COLLATE latin1_general_ci
but you'll need to account for different casing (the COLLATE takes care of this in terms of the search), the word being embedded in another word, extra spaces being left behind.
If 'shiny' only occurs at the beginning then you should use 'shiny%' rather than '%shiny%'. 'shiny %' may also be preferable.
Thank you that worked like a charm.
Posted 19 May 2013Thanks all. I did do
but showed nothing.
But after i used
$pkg = $_POST['pkg']; echo $pkg['1']; // or $pkg
all worked fine. Thanks
Posted 19 May 2013well im doing a simple mysql update like so
$fdfsdfdsfsdf = mysql_query("UPDATE users SET available_earning=available_earning+0.0001 WHERE id = '".$owner2."'") or die(mysql_error());
and when there money reaches 0.9999 it will not go over to 1.0000
- Member Title:
- D.I.C Head
- Age Unknown
- Birthday Unknown