My honda has a carpet like material on the inside of the door it is hanging down and I would like to glue it back up... I used a spray adhesive from a can... but when it is warm out it falls back down. Any suggestion on what kind of glue I should use?

I'd go get several small sheet metal screws, with larger washer heads, that will pass through the carpet and bite into the panel. Just don't get too deep... there are wiring harnesses behind the panel.
Good luck.