How to get Fetch_array data

Question

I am making Tournament mod. And I do not know how to correctly do some operations with fetched array.

What my code is doing, is that it takes data from Tournament table and add it to array. Then print it in HTML table, so all users can see the place where he has. How can I correctly get the first, second, third array data for the first 3 winners and give them a price? And how can I deal with players who have the same amount of points?
Right now the query below seems to not work too, all statements are positiv and it should execute the function.

if($counter == 1) {
    $GLOBALS['DATABASE']->query("UPDATE  ".USERS." SET `atm` = `atm` + 20000  WHERE `id` = ".$recordRow['id_owner']." ;");
}

Sorry, my English is not good and I tried to search for the answers but didn't find anything, because i do not know for what PHP solution should i search.

My code:

$recordFetch = $GLOBALS['DATABASE']->query("SELECT *FROM `uni1_tournament` ORDER BY wons DESC;");
$counter = 0;
$RangeList  = array();
while ($recordRow = $GLOBALS['DATABASE']->fetch_array($recordFetch)) {
    $counter += 1;
    $RangeList[]    = array(
        'id'        => $recordRow['id_owner'],
        'name'      => $recordRow['name'],
        'points'        => $recordRow['wons']*5,
        'counter'       => $counter,
    );

    if($t_time > TIMESTAMP) {
        if($counter == 1) {
            $GLOBALS['DATABASE']->query("UPDATE  ".USERS." SET `atm` = `atm` + 20000  WHERE `id` = ".$recordRow['id_owner']." ;");
        }
        elseif($counter == 2) {
            //to do;
        } elseif($counter == 3) {
            //to do;
        }               
    }   
}

could probably help dba.stackexchange.com/questions/13703/… — Kevin
– Kevin, Commented Jun 27, 2018 at 9:52

sandip bharadva · Accepted Answer · 2018-06-27 10:14:39Z

1

Make query like this "select * from uni1_tournament GROUP BY points ORDER BY points desc limit 3";

answered Jun 27, 2018 at 10:14

sandip bharadva

6341 gold badge6 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hex · Accepted Answer · 2018-06-27 11:35:56Z

1

If you're using regular mysql or mysqli (been a while since I have for either, moved to doctrine a while back), fetch_array needs to be ran on the results and not the GLOBALS['DATABASE'] variable (guessing this a global variable for the database connection).

Try changing

while ($recordRow = $GLOBALS['DATABASE']->fetch_array($recordFetch)) {

to

while ($recordRow = $recordFetch->fetch_array()) {

In order to use your original formatting, I believe fetch_array needed to be mysqli_fetch_array instead.

i.e

while ($recordRow = $GLOBALS['DATABASE']->mysqli_fetch_array($recordFetch)) {

answered Jun 27, 2018 at 11:35

Hex

2411 silver badge10 bronze badges

1 Comment

Thranduil Over a year ago

I have DB class what use MYSQLI functions. Also i remake the first answer a bit and i get what i needed. Thanks

Collectives™ on Stack Overflow

How to get Fetch_array data

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related