hi...i am working on visual basic 6 and i need to pass the value to the database MySQL via ODBC, it is working fine juz leaving a small bug here, the code shown below:
If player X wins, data below will be stored at MySQL:
blnAddMode = True
rs.AddNew
rs!Player = Trim("X")
rs!Date = Now
rs!Status = Trim("Player X Win")
rs.Update
blnAddMode = False
rs.Close
rs.Open
However i still have the level chosen by the user need to add to the same row:
| NULL | NULL | NULL | Mindless |
| X | 3/30/2008 7:51:53 PM | Player X Win | NULL |
| NULL | NULL | NULL | Mindless |
| O | 3/30/2008 7:52:53 PM | Player O Win | NULL |
| NULL | NULL | NULL | Mindless |
| X | 3/30/2008 7:53:10 PM | Player X Win | NULL |
| NULL | NULL | NULL | Mindless |
| O | 3/30/2008 7:54:49 PM | Player O Win | NULL |
| NULL | NULL | NULL | Mindless |
| O | 3/30/2008 7:54:55 PM | Player O Win | NULL |
| NULL | NULL | NULL | Mindless |
| O | 3/30/2008 7:54:59 PM | Player O Win | NULL |
it seems to be in different row, how can i make it to the same row? thanks
+--------+----------------------+--------------+----------+