dbExec and dbQuery

[Msypon]

Guys i would like to know when i should use these functions

[tosfera]

You'll be using the dbExec and dbQuery whenever you want to do something with your database. As far as I used them, I used the dbQuery for select queries and the dbExec for updates, inserts and delete queries.

[myonlake]

dbQuery also returns information, while dbExec just returns a boolean whether the execution was successful or not.

dbQuery returns possible selected rows, number of affected rows and last insert id (alternatively error code and error message), which are useful sometimes when executing insert statements and you want to know the auto-incremented ID.