Yup both MYSQL version have different syntax value when i have upload my current script on MYSQL 5 Host i am getting syntax 27 error but my friend succeeded to change value but now he is offline for 4 months so i am not able to get anyone help but if i don't get reliable host i am going to host current script on current MYSQL 5 server and will take help from any professional guy.
That is the best way to solve your problem because you will hardly get any host that supports mysql4 coz it's an outdated version.