mysql_fetch_array

[slighltywhacked]

When using:

while ($article_info = mysql_fetch_array($result)) // List contents of row
{

do whatver

}

If I use $article_info after the loop, I get nothing because it has already gone through all the rows in $result. How do I get it to start from the begining again?

[Hartmann]

Are you using $article_info like this:

while ($article_info = mysql_fetch_array($result)) // List contents of row 
{
    echo $article_info["column name"];
} 

??

I would just do another $article_info = mysql_fetch_array($result);
after the while loop.

Hope that helps.

[pedro_gb]

Apparently mysql_data_seek() should do the job. I've never used it but here's a guess on how to reuse $article_info:

while ($article_info = mysql_fetch_array($result)) // List contents of row 
{
    echo $article_info["column name"];
}
mysql_data_seek ($result,0);
// do it again!
while ($article_info = mysql_fetch_array($result)) // List contents of row 
{
    echo $article_info["column name"];
}