Sql array only showing first result

Question

I want to put the results in variables seperately but for that I will need to be able to call them separate. Right now I have this query that retrieves 6 results (tested with mysqli_num_rows). But when I print it, it will only shows the first row from my 6 results.

$result =  mysqli_query ($con, $query) or die("FOUT: " . mysqli_error($con));

echo "<p>mysqli_num_rows($result)</p>";

$row = mysqli_fetch_row($result);
print_r($row);
mysqli_free_result($result);

Results from

print_r($row) = 

Array ( [0] => Iran [1] => 28 )

What does the query look like? fetch_row not fetch_rows — Kyslik
– Kyslik, Commented Dec 2, 2014 at 18:50
Hi, the query is: $query ="SELECT * FROM WKaverage WHERE Average > 27.8"; but that works fine on mySQL. — Jeak
– Jeak, Commented Dec 2, 2014 at 18:51
You will need to call mysqli_fetch_row() for each single row. — Cyclonecode
– Cyclonecode, Commented Dec 2, 2014 at 18:51

Cyclonecode · Accepted Answer · 2014-12-02 18:53:18Z

2

To get all rows you will need to do something like:

$rows = array();
while($row = mysqli_fetch_row($result)) {
   $rows[] = $row;
}
// $rows will now contain all rows in the result set

answered Dec 2, 2014 at 18:53

Cyclonecode

30.4k11 gold badges77 silver badges97 bronze badges

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

5 Comments

Jeak Over a year ago

Thanks man, you are right! Will give you 'accept answer' in 8!

Kyslik Over a year ago

is $rows init required? (less code better code, easy to read code better code)

Cyclonecode Over a year ago

@Kyslik - no that won't be needed.

Cyclonecode Over a year ago

@Kyslik - Although I would strongly recommend that you initialize the array as it makes the code clearer and also shows what data $rows is meant to hold. Also, I don't agree that less code always means easier to read and better code

Kyslik Over a year ago

@KristerAndersson I asked that question in educational way, I know that in PHP you do not have to initialise variables. Some prefer less code some prefer more readable code. Thanks tho ;), MisterAnderson! good nick.

versalle88 · Accepted Answer · 2014-12-02 18:51:33Z

1

Your function, mysqli_fetch_row(), only returns a single row result:

http://php.net/manual/en/mysqli-result.fetch-row.php

Try looping through like this:

while ($row = mysqli_fetch_row($result) {
    // Do something
}

Thanks,

Andrew

answered Dec 2, 2014 at 18:51

versalle88

1,1471 gold badge7 silver badges19 bronze badges

2 Comments

Marc B Over a year ago

yes and no. ALL of the fetch functions return a single row. You need to fetch in a loop.

Cyclonecode Over a year ago

This will also just return a single row.

Shir Gans · Accepted Answer · 2014-12-02 18:57:15Z

0

You should use while

    while ($row = mysqli_fetch_row($result)){
print_r($row);
//do more stuff...
}

You can use fetch_assoc instead of fetch_row to have logical array keys

answered Dec 2, 2014 at 18:57

Shir Gans

2,0374 gold badges24 silver badges40 bronze badges

Comments

Rohìt Jíndal · Accepted Answer · 2014-12-02 18:58:42Z

0

Try this it will work :

$result =  mysqli_query ($con, $query) or die("FOUT: " . mysqli_error($con));

echo "<p>mysqli_num_rows($result)</p>";

$rows = array();
$row = mysqli_fetch_row($result);

do
{
   $rows[] = $row;

}while($row = mysqli_fetch_row($result))

mysqli_free_result($result);

answered Dec 2, 2014 at 18:58

Rohìt Jíndal

27.4k16 gold badges80 silver badges133 bronze badges

Collectives™ on Stack Overflow

Sql array only showing first result

4 Answers 4

5 Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

5 Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related