I am a newbie to PHP and MySQL. I currently do all my stuff in ASP and would like to learn the power of PHP. One of the things I am wondering is if you can do like asp and put all the records into an array so you would loop through the array not each record. I see the function mysql_fetch_array does fetch one row at a time but can I do a dynamic array like this?

Also please fill me in if PHP doesn't really matter if you hit each record since it may be more efficient at this. I don't have a clue. Someone please educate me on this.

Thanks in advance for your help.