[PHP] accessing mysql_fetch_array more than once?

Hi all, Howcome, when I do a SQL lookup, I can only access the array once? Say, I have... ? $SQL = mysql_query(SOME SELECT STATEMENT); while ($var = mysql_fetch_array($SQL)) { echo $var['columbname']; } // that works, and prints out the rows in the table // my codes continues. ? some

Re: [PHP] accessing mysql_fetch_array more than once?

reset() On Fri, 17 May 2002, Chris Knipe wrote: Hi all, Howcome, when I do a SQL lookup, I can only access the array once? Say, I have... ? $SQL = mysql_query(SOME SELECT STATEMENT); while ($var = mysql_fetch_array($SQL)) { echo $var['columbname']; } // that works, and prints out

Re: [PHP] accessing mysql_fetch_array more than once?

] accessing mysql_fetch_array more than once? reset() On Fri, 17 May 2002, Chris Knipe wrote: Hi all, Howcome, when I do a SQL lookup, I can only access the array once? Say, I have... ? $SQL = mysql_query(SOME SELECT STATEMENT); while ($var = mysql_fetch_array($SQL