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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

