Jenny, I'm assuming he's wanting a full-size tripod.
Vector, what type of camera, and how much do you want to spend? Like anything else in the photography world, you definitely get what you pay for. The cheap Wal-Mart specials won't hold up, or keep a heavy camera like a DSLR steady. OTOH for a point & shoot, it would probably be fine.
If you have a DSLR with a zoom lens, for best results you really need a higher-end tripod, something approaching pro-level. At that level, the legs and head are purchased separately (although most shops will sell a combo deal). If you want lightweight for extended hauling, carbon fiber legs are the way to go but quite pricey compared to alloys, around $200-$300 just for the legs. And nice heads, especially ball heads, are very heavy, as well as pricey. They're all metal, not plastic like the el-cheapo panheads you find on the Wal-Mart specials.
You could easily spend $1000 if you wanted to, but that isn't necessary for the vast majority of us. For reference, I recently purchased the
Slik Pro 700DX AMT[=http//www.bhphotovideo.com/c/product/557127-REG/Slik_615317_Pro_700_DX_Tripod.html]Slik Pro 700DX AMT titanium alloy legs and this
Bogen-Manfrotto ball head[=http//www.bhphotovideo.com/c/product/272780-REG/Bogen_Manfrotto_488RC4_488RC4_Midi_Ball_Head.html]Bogen-Manfrotto ball head for my DSLR. A little over $200 total, it's very nice and well-built, but I wouldn't want to be hiking with it for very long unless I had it rigged to a backpack, because it's heavy. Even with the titanium alloy legs, the hinges, base, ball head, etc. are massive hunks of metal. All together it weighs about 7 pounds.
You can find some Slik combo deals at B&H with a pan head for around $100 or a little more if you want to spend that much. But again, if you don't have a DSLR I don't see the point -- the Wal-Mart special will probably work okay for you.