<div>
There's no way to do that; once you've fetched a row from the database it's up to you to do whatever you want with it before moving on. 
 
If you're interested in keeping all the rows around, consider something like... 
 
while ($row = mysql_fetch_aray($datasetRemark)) 
&nbsp; &nbsp; $rows[] = $row; 
 
(so you'll end up with an array $rows that contains each row).
</div>

There's no way to do that; once you've fetched a row from the database it's up to you to do whatever you want with it before moving on.

If you're interested in keeping all the rows around, consider something like...

while ($row = mysql_fetch_aray($datasetRemark))
    $rows[] = $row;

(so you'll end up with an array $rows that contains each row).

<div>
VoteyDisciple, 
 
Thanks very much for the info, would you happen to know how can we use $rows[] in our second condition? 
how would the code look like ? 
 
//2nd time accessing 
... 
...
</div>

VoteyDisciple,

Thanks very much for the info, would you happen to know how can we use $rows[] in our second condition?
how would the code look like ?

//2nd time accessing
...
...

<div>
<div class="content wysiwyg-content">
Hi, 
 
Please assist how come when I tried to use &quot;mysql_fetch_array($datasetRemark)&quot; the second time nothing came-up, do we need to reset or move to first record? 
 
I'm trying to access the same dataset that had been used earlier. 
 
Thanks. 
 
 
//this is only for sample... 
while ($row = mysql_fetch_array($datasetRemark)) 
{ 
if ($row['RemarkID']==&quot;1&quot;){$Counta = $Counta + 1;} 
} 
echo $Counta; 
 
 
//2nd time accessing 
while ($row = mysql_fetch_array($datasetRemark)) 
{ 
if ($row['RemarkID']==&quot;1&quot;){$Countb = $Countb + 1;} 
} 
echo $Countb; 

</div>
</div>

Hi,

Please assist how come when I tried to use "mysql_fetch_array($datasetRemark)" the second time nothing came-up, do we need to reset or move to first record?

I'm trying to access the same dataset that had been used earlier.

Thanks.


//this is only for sample...
while ($row = mysql_fetch_array($datasetRemark))
{
if ($row['RemarkID']=="1"){$Counta = $Counta + 1;}
}
echo $Counta;


//2nd time accessing
while ($row = mysql_fetch_array($datasetRemark))
{
if ($row['RemarkID']=="1"){$Countb = $Countb + 1;}
}
echo $Countb;


mysql_fetch_array

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.