my car works in reverse but not in drive

This is a simple case of that your transmission is shot (assuming that it IS an automatic transmission). It is possible -- and happens often -- that your forward friction plates are shot, but the reverse ones are fine.