If I do not drive the car will the battery drain in a 1994 Honda accord?

How long with no driving?

Yes, it will likely need to be placed on a charger after 5 months, particularly in hot weather.