Fixed, but not really :)
I copied the hosted database to my local machine, which is running Wamp 2.0 with MySQL 5, and the query worked fine. So I created a new database with 1and1 1and1, only this time with MySQL 5 instead of MySQL 4, and it works fine. Not too sure why it wouldn't work with 4, maybe some syntax change or something? I guess that brings me to the question, when Webassist designs their products, are they designed around Mysql 5 or 4?
Thank you for the help and insight!