my dream is to be able do it like that: <?php $pdo = new PDO('sqlite:database.DB3'); $pdo->query("INSERT UPDATE table SET value1='somedata', value2=somedata, id=$getid ") ?>
when $getid contains data (a number of course) then an update is performed, otherwise if it is null then database engine ignores `id` valule without any notification and INSERT is performed with adding new id... -- View this message in context: http://www.nabble.com/one-liner-for-insert-or-update---tp25416164p25416164.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users