Not sure if anyone read your post, but what you are going to want to do is find a personal trainer if you want someone to show you the ropes. However, you can also just look online for beginner routines.

It's all about how many times a week you can go and consistency. Everyone does their own thing that works well for them, and while some are better than others, the most important thing is consistency.

After you do that, go get a planet fitness membership (try not to pay a sign up fee if you can help it) and spend the $10 a month learning about lifting and getting comfortable. At some point you may want to upgrade to a higher quality gym and as others have said, fit lab is good, YMCA and then you start getting into more "country club" style places that offer more than just a gym but other benefits as well.

Good luck!