Hi again.

I am trying to make a new Register script. But now, there is only one thing that is not working.. I can't make the following query work.




this is the current date variable, that is causing the error. (if I remove it from the query, it works just fine)


this is the error I am getting:




in the database I gave it the data type int, because the date is only made out of numbers.

Thanks for your help //Feelay

This post has been edited by Feelay: Jun 11 2008, 07:39 AM

Your query don't work because your variable stores a string like "2008/06/13", the "/" character cause this error to happen.

To fix it simply change your variable's date format to:


But this can lead to get problems with the register_date field, i'm not sure about this.

A better solution is to change the data type of the register_date field to date and change the sql query to:


Best regards,

Thanks ^.^

lol I forgot that "/" was in the variable
Anyways.. it is working now =)

Thank you //Feelay