inserting data to table

[ganie17]

hello guys...
I'm here again... i just want to ask if can I insert the follwing data to a table:

password -> Cusername field
username -> Cpassword field
currentdate -> date field
customer number -> customerno field

I'm having a syntax error spcifically in inserting the current date when the user login my site.

thanks in advace...

by the way, my table name is Custlogin and the following fields are :
Cusername,Cpassword,Date,CustomerNo

[TimM]

Can you post the code that is causing the syntax error?

[coopster]

Make sure that the date you are using to populate the date column type is formatted correctly. You can always echo the sql query statement to the browser to see what it looks like before you execute it. Helps a lot to troubleshoot these types of issues.