argh
Sorry, was getting a little frustrated, but found out why it wasn't let me change it from int(10) to varchar(4). MySQL automatically inserts the closing ) where MSSQL doesn't, so I was having 2 )'s in the command, which of course, would give a syntax error.
So, after seeing that, changing a few more things, it appears it is working now. Well, still have to test the paypal link...