You will need a jailbroken 3G or 2G iPhone running firmware 3.1.2.  The 2G/3G Video MMS Enable app is available on Cydia for free.  Just add http://repo.modyouri.com to your sources in Cydia and then search for the app.