Reseting $row internal pointer - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

bodis · 04-11-2011, 04:16 PM

Hi,

I wonder if someone could help me out with the following. I am new to php so please bare with me.

I am using the following loop to go through the data:

Code:

while ($row1 = mysql_fetch_array($players))
{
  if ($row1['t_id'] != $row['team1'])
  {
    echo "<option value='name'>" . $row1['name'];
  }
}

However I need to do this all over again in the next row but am struggling to move the array pointer to the start.

I have tried
echo reset($players); and
echo reset($row1);
but get the error that these are not arrays. I am a bit confused and any help would be really appreciated.

Many Thanks
bodis

chunnilal · 04-12-2011, 11:45 AM

try doing it this way....as many times as u want...

mysql_result($rs,0,team1);

_________________________________
Share Knowledge, No crap

bodis · 04-12-2011, 01:59 PM

Thanks for mentioning this as by googling it I came upon the function that I needed:

mysql_data_seek($result, 0)

Thanks again
bodis

chunnilal · 04-13-2011, 05:56 AM

Ur welcome.... U can refer to this link for further probs.