Mysqli fetch array nth row

Question

I have the following code that fetches a single row:

$query = "SELECT *
          FROM translations
          WHERE iddoc = '$id'
          AND submitted = 1;";
$result = mysqli_query($query);
$row = mysqli_fetch_array($result);

I know this is useful in a while loop, where you can just loop through the results.

But I need to be able to grab specific rows that meet this condition. Something following this pseudo code:

$query = "SELECT *
          FROM translations
          WHERE iddoc = '$id'
          AND submitted = 1;";
$result = mysqli_query($query);
$arrayofrows = mysqli_fetch_arrayofrows($result);
$arrayofrows[0] //(to get the first row)
$arrayofrows[1] //(2nd row)

and so on...

How can I do this?

Is that the best (only) way to do it? I can't return an array of all of the results? — sir_thursday
– sir_thursday, Commented Aug 25, 2012 at 23:05
http://www.php.net/manual/en/mysqli-result.fetch-all.php, I guess this should help — Hawili
– Hawili, Commented Aug 25, 2012 at 23:06

codingbiz · Accepted Answer · 2012-08-25 23:15:43Z

7

You can try something like this

$arrayofrows = array();
while($row = mysqli_fetch_array($result))
{
   $arrayofrows = $row;
}

You can now have

$arrayofrows[0] //(to get the first row)
$arrayofrows[1] //(2nd row)

answered Aug 25, 2012 at 23:15

codingbiz

26.4k9 gold badges62 silver badges99 bronze badges

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

2 Comments

sir_thursday Over a year ago

OOOH that's sneaaaky. I could even name it as a function and use it globally.

Tinel Barb Over a year ago

while($arrayofrows[] = mysqli_fetch_array($result)) or use of mysqli_fetch_all would be enough.

user2072402 · Accepted Answer · 2014-02-20 23:24:06Z

3

I think the function you are looking for is mysqli_fetch_all as shown below. This avoids the need to create an extra looping structure or a function to do something already provided.

$query = "SELECT *
          FROM translations
          WHERE iddoc = '$id'
          AND submitted = 1;";
$result = mysqli_query($query);
$arrayofrows = mysqli_fetch_all($result);
$arrayofrows[0] //(to get the first row)
$arrayofrows[1] //(2nd row)

answered Feb 20, 2014 at 23:24

user2072402

313 bronze badges

Comments

Sammaye · Accepted Answer · 2012-08-25 23:15:07Z

2

It depends on whether you require the entire result set back or not but I think the LIMIT could be used like:

$query = "SELECT *
          FROM translations
          WHERE iddoc = '$id'
          AND submitted = 1 LIMIT 200,200;";

Otherwise as others say you will need to convert to an array (which is what fetch_all does) and then get the element from that array.

answered Aug 25, 2012 at 23:15

Sammaye

44k7 gold badges110 silver badges149 bronze badges

1 Comment

Ruth Over a year ago

Thanks @Sammaye, as a matter of fact if only a set of consecutive rows is needed, the LIMIT {[offset,] row_count | row_count OFFSET offset}] is perfect

Collectives™ on Stack Overflow

Mysqli fetch array nth row

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related