使用end（$ array）检索数组中的最后一行

Question

After doing some research I hear that to retrieve the last row on an array I can use end($arrayname)

However when putting this into my page it does not retrieve the last, but the first in the array.

$query2 = "SELECT * FROM Items";
$resultSet2 = mysql_query($query2);


while ($row2 = mysql_fetch_array($resultSet2, MYSQL_ASSOC))
{
$lastElement = end($row2);
echo $lastElement;
}

Looping through the array like this will loop through and display every row in the array one after the other: Agate & Labradorite Necklace.jpgAgate Necklace.jpgAventurine, Citrine and Carnelian Necklace.jpg

However I was under the impression it should simply repeat the last item (Carnelian necklace.jpg) every time

$row2 = mysql_fetch_array($resultSet2, MYSQL_ASSOC);
$lastElement = end($row2);
echo $lastElement

This will print the first item in the array. Any ideas what is causing this to happen?

Answer 1

You are applying end to $row2, which already represents a row of data. This makes $lastElement be the last column of each row (the while iterates over rows).

It would not make sense to fetch N items just so that you can repeat the last one of them N times (in addition: your SQL query does not specify a sort order, so which item is going to be last is also unknown to you). If you wanted to do something like that you would fetch one item using LIMIT 1 and the number N using an appropriate query and finally simply use a for loop.