Generally, Windows hosts support ASP with MsSQL and Linux hosts support PHP with MySQL, but that is in no way binding. ASP can be supported under Linux and vice versa.
If yours is just a small site it shouldn't matter so much either way.
I am pretty new to web design and coding in general and am currently looking into getting setup with a host. I understand that many hosts offer a choice between Windows and Linux/Unix hosting -- can anyone recommend me either way?
My needs are pretty basic -- Just a small website with some photos on it. I would, however, like to implement a password module of some sort so that visitors must login to access a restricted part of the site.
Thanks
-dynocomet

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic