<?php $Query = $MySQL->query("SELECT `value` FROM `info` WHERE `name`='current_game'"); $Fetch = $Query->fetch(); $GameNumber = 'game'.$Fetch['value'].''; $Query = $MySQL->prepare("SELECT * FROM :one"); $Query->bindValue(":one", $GameNumber, PDO::PARAM_STR); $Query->execute(); while($Fetch = $Query->fetch()) { $Data[$Fetch['userid']]['value'] += $Fetch['value']; $Data[$Fetch['userid']]['items'] .= '<div class="item"> <img src="http://steamcommunity-a.akamaihd.net/economy/image/'.$Fetch['image'].'/70fx58f"> <div class="itemdescription">'.$Fetch['item'].'</div> </div>'; $Data[$Fetch['userid']]['name'] = $Fetch['username']; $Data[$Fetch['userid']]['avatar'] = $Fetch['avatar']; } foreach($Data as $Key => $Value) { $Info .= '<div class="bet"> <div class="user"> <img src="'.$Data[$Key]['avatar'].'" width="38" height="38"> <span class="username">'.$Data[$Key]['name'].'</span> <span class="betamount">'.$Data[$Key]['value'].'$</span> </div> <div class="items">'.$Data[$Key]['items'].'</div> </div>'; } ?>
Jakies pomysly?