I Need help converting ASP over to PHP

set rsSubMenu = connDB.execute("SELECT * FROM pagetable WHERE mainid = '" & pageid & "'")

if rsSubMenu.EOF then

else
firstpage = rsSubMenu("pageid")
rsSubMenu.MoveNext
end if

this i the asp code that im having problems with, its essentially just the line

rsSubMenu.Movenext

I'm not sure exactly how PHP does this.
I know that PHP automatically cycles through the query row by row, but I dont quite think its what im looking for.
Can anyone help??

Hi Dryft,
PHP uses mysql_fetch_row or mysql_fetch_array to grab the next record in a query result, like this:

$row = mysql_fetch_row($dbResult);

or you can setup a while loop, like this:

while($row = mysql_fetch_row($dbResult))
{
print_r($row);
}

I'll go about trying to get that to work.

Thanks mytch.