I am using Dreamweaver MX as a frontend to upload data to a MySQL table. In my table there is a date field that when the user clicks submit the date will be populated automatically. Can someone tel me how to do this? Thanks.
First you can create a timestamp field. If you create a new record or update one, MySql will update this field with the system date.
An other solution is to use NOW() function to retreive the current date.
I imagine part of your WHERE clause includes the date... Show us the VB code that you are using to assemble the query or the part that actually generates the date you concatenate to the end of the WHERE clause. It may be in the wrong format.
Sorry, I had a few extra lines in there. This is what I have.
Private Sub Form_Load()
Dim rs11 As ADODB.Recordset
Dim DB11 As New ADODB.Connection
Dim ssql2 As String
ssql2 = "select * from help_desk"
DB11.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;Data Source=survey"
Set rs11 = New ADODB.Recordset
rs11.CursorType = adOpenKeyset
rs11.LockType = adLockOptimistic
rs11.CursorLocation = adUseClient
rs11.Open ssql2, DB11
Do Until rs11.EOF