I have a 96 Camry (4cyl) The car did not move when put in Drive and in reverse. I check the oil, it was kind of brownish
It makes a weird noise to, near the starter/ bellhousing

 

Determine if the shift arm on the side of the trans is moving in sync with the shift selection console, the cable can break.

If OK a few causes could be a bad torque converter clutch or plugged oil intake screen. The pan can be removed to check the screen. Also completely change the fluid (about 6 quarts). Do about 4 drain and refills with a few miles in between to get most of the old oil out, about 2/3rds is always in the converter.