good carpet cleaning products?

its going to be a driver with a black interior, and rite now my budget isnt really leaning towards a new premolded carpet, so i think i may go the home depot route....just wondering though now that you mentioned it, will this carpet you guys are talking about withstand water? and will it stay in place even though it isn't premolded?