MySQL mysqli - returning rows in an array

Question

I have the following code:

$query6 = "SELECT TIMESTAMP As sDate, COUNT( TIMESTAMP ) AS Total 
           FROM tresults GROUP BY TO_DAYS( timestamp ) ";

$result6 = $mysqli->query($query6);

$rows = array();

while($row6 = $result6->fetch_array())
    {
        $rows[]=$row6;
    }

Whilst this works, the output is as follows but isn't what I expected:

Array ( [0] => Array ( [0] => 2014-05-14 02:11:16 [1] => 1 ) 
[1] => Array ( [0] => 2014-05-19 05:05:17 [1] => 76 ) 
[2] => Array ( [0] => 2014-05-20 00:28:41 [1] => 35 ) 
[3] => Array ( [0] => 2014-05-21 01:24:01 [1] => 25 ) )

I had expected the result to be in a single array not multi-arrays.

Clearly the output is correct based on my code but what I am struggling with is then (within PHP) looping through the above array and echo'ing the output.

If anyone can advise on the code need to either loop through the above correctly or advise on changing the above so the output is within one array (which I know how to loop through) - that would be appreciated.

Which row do you need? If you need to print details of every row then don't create a new array, just use echo on the array that you are looping over — Hanky Panky
– Hanky Panky, Commented Jun 5, 2014 at 16:06
Where did I ask for a single value to be stored? Why the downvote? — Homer_J
– Homer_J, Commented Jun 5, 2014 at 16:07

Paul S. · Accepted Answer · 2014-06-05 16:09:27Z

1

You can echo out the content in the while loop instead of inserting each row into a giant array.

while($row = $result6->fetch_array())
{
    echo $row[0] . ' ' . $row[1];
}

If you want to deal with the giant array after the while loop, you can use a foreach loop:

foreach ($rows as $row => $record)
{
    echo $record[0] . ' ' . $record[1];
}

The foreach loops through each array and returns the value as $record (in this case it is the inner array).

answered Jun 5, 2014 at 16:09

Paul S.

1,5479 silver badges13 bronze badges

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

1 Comment

Homer_J Over a year ago

appreciate you taking the time to respond. Thank you.

Collectives™ on Stack Overflow

MySQL mysqli - returning rows in an array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related