I made a section with water and from above it looks like this:
http://i205.photobucket.com/albums/bb49/deisen/dod_madeleine0000.jpg

And from below:
http://i205.photobucket.com/albums/bb49/deisen/dod_madeleine0001.jpg

How do i make it so i cant see the bottom from above?

Use a murky water. There is one with the name of something like canals_murkey water blah blah blah.

Here is a list of waters available w/pics:

http://www.dimensionstudios.org/forum/index.php?showtopic=576

:D

Also, water doesnt show up unless you do a full vrad (lighting) compile