The car idles fine but when you put into drive and try to accelerate it doesn't

Hello, This is likely due to a failed clutch (if a manual transmission), or the torque converter.transmission may be suffering failure (if an automatic transmission). You will need to have the automatic transmission diagnosed, but a manual transmission with a bad clutch is easily diagnosed by the reduction in friction between the engine and transmission (slipping).