Leaderboard

You never get back your money that you wagered. So what you are using as an example is NOT correct still. If the odds are 2 to 1 that means you win twice as much as you bet. So the result is 100 But in actually all you did was get your money back and a 50 profit which is a 1 to 1 bet, not 2 to 1. So if the odds are even (1 to 1), what do you get back? Just the 50 that you bet? Are you sure about this? What county is there, cause I never want to gamble there!

https://www.google.com/search?q=filezilla+keyboard+shortcuts

If you want to use silly names like that with the "." at the end then you need the column name inside backticks. SELECT `KNr.` FROM .... From MySQL manual

$json = '[{"id":"1","category":"public health","type":"top"},{"id":"2","category":"environment","type":"top"},{"id":"3","category":"global unrest","type":"top"},{"id":"4","category":"military","type":"top"},{"id":"6","category":"super powers","type":"top"},{"id":"7","category":"technology","type":"top"},{"id":"8","category":"human rights","type":"top"},{"id":"60","category":"space race","type":"top"},{"id":"67","category":"globalism","type":"top"},{"id":"87","category":"government","type":"top"}]'; $array = json_decode($json, 1); // decode as an array $column = 'category'; $categories = array_column($array, $column); // get the $column values echo '<pre>' . print_r($categories, 1) . '</pre>'; gives Array ( [0] => public health [1] => environment [2] => global unrest [3] => military [4] => super powers [5] => technology [6] => human rights [7] => space race [8] => globalism [9] => government )