Best database saving?

[denny199]

So I still need to use dbQuery instead of dbExec?

And i found this:

SELECT * FROM myTable WHERE DATE(myDate) = DATE(NOW())

[google]

So I maybe need to pass direct my accountname? can you give me a example?

[denny199]

Okay guys, let me explain it better:

This is working properly:

dbQuery(handler, "UPDATE playerData SET D2290=5 WHERE ACCOUNTNAME='denny19' " )

But this isn't working properly:

dbExec ( handler, "UPDATE playerData SET `??`= `?` WHERE ACCOUNTNAME = `?` ", Ddata, value, ACCname )

It gives me the same error, and I didn't understood Crystal, because my english isn't so good.

[DiSaMe]

That's because in the second case you are comparing ACCOUNTNAME to `'denny19'` (what means a column name), not 'denny19'. Remove the backticks.

[denny199]

Aaaaaah, thanks man, hahahaha

It worked