mysql_fetch_array pulling fewer results than it should

Question

I have the following code:

$mostRecent = mysql_query("SELECT couponID FROM users_coupons WHERE userID = '$userID' ORDER BY id LIMIT 3");
    while($row = mysql_fetch_array($mostRecent))
    {
        $mostRecentArr = $row;
    }
    var_dump($mostRecentArr);

The same SQL query in the command line returns 3 results, but this code only returns one result, even though I put LIMIT 3. Any help?

Nicola Cossu · Accepted Answer · 2011-05-04 22:45:47Z

4

while($row = mysql_fetch_array($mostRecent))
    {
        $mostRecentArr[] = $row['couponID'];
    }

answered May 4, 2011 at 22:45

Nicola Cossu

56.7k15 gold badges96 silver badges99 bronze badges

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

Comments

David Fells · Accepted Answer · 2011-05-04 22:44:24Z

2

You reassign the value in the loop each time, then dump the last value. Put var_dump in the loop after the assignment. Like so:

$mostRecent = mysql_query("SELECT couponID FROM users_coupons WHERE userID = '$userID' ORDER BY id LIMIT 3");
    while($row = mysql_fetch_array($mostRecent))
    {
        $mostRecentArr = $row;
        var_dump($mostRecentArr);
    }

answered May 4, 2011 at 22:44

David Fells

6,8081 gold badge24 silver badges34 bronze badges

Comments

morgar · Accepted Answer · 2011-05-04 22:48:31Z

1

I guess what are you trying to do is:

$mostRecent = mysql_query("SELECT couponID FROM users_coupons WHERE userID = '$userID' ORDER BY id LIMIT 3");
$mostRecentArr = array();
while($row = mysql_fetch_array($mostRecent))
{
    $mostRecentArr[] = $row;
}
var_dump($mostRecentArr);

answered May 4, 2011 at 22:48

morgar

2,41718 silver badges17 bronze badges

Collectives™ on Stack Overflow

mysql_fetch_array pulling fewer results than it should

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related