I was thinking about purchasing a 2006 honda accord and was wondering what I can do about connecting my iPod to it?

Go for the harmon kardon drive + play available at apple.ca. It goes for $249.99.

According to the Honda website the 2006 Accord offers iPod integration as an accessory.

http://automobiles.honda.com/models/audio_accessories.asp?ModelName=Accord+Sedan