mysqli fetch_array() is only turning first row of retrieved data into an array

Question

What seems to be happening is $result_tag is only holding the first row of the sql data retrieved.

When I run the result query on SQl in returns a table with multiple rows. However, when I var_dump() it, it only returns the first row and nothing else.

  while($row = $results->fetch_array(MYSQLI_BOTH)) {    
  echo ....stuff that dont matter

  //Now I want some SQL results based on a result from ^^^ $row['ID']
  $result = $conn->query("SELECT tags.Tag FROM tags WHERE tags.results_ID =".$row['ID'] );
  $result_tag = $result->fetch_array(MYSQLI_NUM); 

  //I got the results. Now I want to compare them to another array '$explode' 
  //and echo out elements that are the same

    foreach($explode as $explodeValue){
      foreach($result_tag as $tag){
        if($tag == $explodeValue){
          echo $explodeValue;
        }
      }
    }

}//end of 1st while

chopper · Accepted Answer · 2014-11-29 05:48:07Z

1

You want to use fetch_all(); fetch_array() returns just one row (as an array) See http://php.net/manual/en/mysqli-result.fetch-all.php

This is in fact what the outermost while is doing, fetching one row at a time with fetch_array()

edited Nov 29, 2014 at 5:48

chopper

6,7397 gold badges40 silver badges56 bronze badges

answered Nov 29, 2014 at 5:38

Andras

3,05515 silver badges17 bronze badges

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

Comments

Rafael · Accepted Answer · 2014-11-29 04:55:02Z

1

Change to

$result = $conn->query("SELECT * FROM tags WHERE results_ID =".$row['ID'] );

answered Nov 29, 2014 at 4:55

Rafael

7,79613 gold badges36 silver badges49 bronze badges

Collectives™ on Stack Overflow

mysqli fetch_array() is only turning first row of retrieved data into an array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related