Having an odd problem with mysql_fetch_array()

Question

Why am I not able to get inside the while loop in the getCustomers() function?

$stores = $bl->getStoresForGuide($gID);  //Returns 6 stores
$storelist = getStoreList($stores);      //Generate the HTML for the store list
$brandlist = getCustomers($stores);      //Generate the HTML for brand list

function getStoreList($stores) 
{
  while ($row = mysql_fetch_array($stores)) {
    // Do stuff 
  }
 //return result
}


function getCustomers($stores)
{
  echo mysql_num_rows($stores);  //Outputs 6

  while ($row = mysql_fetch_array($stores)) {
    echo "test "; // Outputs nothing
  }
  // Return some result
}

Jerod Venema · Accepted Answer · 2010-01-26 00:50:34Z

5

You're looping twice. The first time you loop, you get to the end, and the pointer isn't reset before you loop again.

If you're sure you want to do this, check out mysql_data_seek, and seek to the beginning of the result. Otherwise, I'd recommend just storing the results and iterating over the array.

answered Jan 26, 2010 at 0:50

Jerod Venema

44.7k5 gold badges70 silver badges109 bronze badges

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

1 Comment

Steven Over a year ago

Thanks. Didn't know that. I put the result in an array, and it works fine now.

echo · Accepted Answer · 2010-01-26 00:51:49Z

0

You are calling getStoreList first, then by the time you call getCustomers, $stores has already had all its rows fetched.

answered Jan 26, 2010 at 0:51

echo

7,9252 gold badges38 silver badges33 bronze badges

Collectives™ on Stack Overflow

Having an odd problem with mysql_fetch_array()

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related