Incrementing a value using pdo (mysql)

[RobertP]

$connection->exec('update plugin_advertisements set out = out+1 where id = '.intval($id).';');

$connection->execute('update plugin_advertisements set out = out+1 where id = ?;',array($id));

 

no luck with either :S

 

if anyone has had this problem and found a viable solution, maybe you can point me in the right direction?

[PFMaBiSmAd]

out is a reserved mysql keyword and would need to be enclosed in back-ticks to prevent an error in your query. Your query error checking logic would have been giving you an error near the first use of out in the query.

[RobertP]

out is a reserved mysql keyword and would need to be enclosed in back-ticks to prevent an error in your query. Your query error checking logic would have been giving you an error near the first use of out in the query.

 

thank you so much (did'nt know about the out-keyword)