I use to use all for loops for looping through database data sets and just started using while loops with mysql_fetch_ type functions and for some reason, the second mysql_fetch loop in the file never seems to fire but does when I switch the second one to a for loop. Does anyone know a reason for this? Is there some type of array pointer that I need to reset or something?
I found it, actually got it from phpfreaks. surprisingly got the answer within 10 minutes of posting. There are a lot of good php users there but its so dry though. I much prefer daniweb. Anyway the function is pg_result_seek().