PHP: sqlite_single_query

(PHP 5)

sqlite_single_query -- Выполняет SQL зпрос и возвращает массив со значениями одного поля или первую запись

Описание

mixed sqlite_single_query ( resource db, string query [, bool first_row_only [, bool decode_binary]] )

Внимание

К настоящему времени эта функция еще не была документирована; для ознакомления доступен только список аргументов.

sqlite_single_query

franp at free dot fr
26-Sep-2004 05:42


AFAIK, you cannot use sqlite-single-query for all kind of SQL queries.

If you are lazy and thought you could safely copy-paste your :

<?php $result = $db->sqlite-single-query($sSQL); ?>

straight from one query to the other, whatever is the query as long as it has only one line, you are wrong.



Apparently, sqlite-single-query is limited to queries that return data, that is to SELECT queries. 



<?php

$sSQL  = "DELETE FROM atoms WHERE ID = '8';";



// The following won't work :

$result = $db->singleQuery($sSQL);



// But the following will :

$result = $db->query($sSQL);

?>