while循环后结果为空

Question

Why is this not possible? Is there some way I can make the resolut not to be empty?

$sqlAllInfo = "SELECT item1, item2 FROM example";
$resAllInfo = mysql_query($sqlAllInfo);

while($rowAllInfo = mysql_fetch_assoc($resAllInfo)){

    echo $rowAllInfo['item1'];

}

$rowAllInfo = mysql_fetch_assoc($resAllInfo);

echo $rowAllinfo['item2'];

Thanks for your time

Answer 1

No, the result will always be empty after your while loop, because the while loop extracts all value from the result resource..
the while loop continues looping while there is still information to extract, and will finish when it is empty or when an error occurs

if you ment to get the last entry $rowAllInfo still contains the last entry ;)