Re: [sqlite] Problem with method numRows() in Sqlite3

2013-09-26 Thread pisey phon
Thanks you . -- View this message in context: http://sqlite.1065341.n5.nabble.com/Problem-with-method-numRows-in-Sqlite3-tp71420p71495.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Problem with method numRows() in Sqlite3

2013-09-24 Thread Simon Slavin
On 24 Sep 2013, at 9:50am, pisey phon wrote: > And now I have an error with insert data into database with Sqlite3. > Errro: "SQLite3::exec() [sqlite3.exec]: near "SET": syntax error". Insert a debugging line into your program so that having make up the full INSERT

Re: [sqlite] Problem with method numRows() in Sqlite3

2013-09-24 Thread pisey phon
And now I have an error with insert data into database with Sqlite3. Errro: "SQLite3::exec() [sqlite3.exec]: near "SET": syntax error". I a a new with Sqlite3 here is my code: open($db_file); } public function connecting($db){ if(!$db){

Re: [sqlite] Problem with method numRows() in Sqlite3

2013-09-24 Thread pisey phon
thanks you so much for replying it really help me -- View this message in context: http://sqlite.1065341.n5.nabble.com/Problem-with-method-numRows-in-Sqlite3-tp71420p71439.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users

Re: [sqlite] Problem with method numRows() in Sqlite3

2013-09-23 Thread Tim Streater
On 23 Sep 2013 at 04:50, pisey phon wrote: > I got an error "Call to undefined method SQLite3Result::numRows()". and here > is my code: > $db = new Sqlite3("sample.db"); > $result = $db->query("select * from table"); > $rows = $result->numRows(); Sorry, ignore my last

Re: [sqlite] Problem with method numRows() in Sqlite3

2013-09-23 Thread Tim Streater
On 23 Sep 2013 at 04:50, pisey phon wrote: > I got an error "Call to undefined method SQLite3Result::numRows()". and here > is my code: > $db = new Sqlite3("sample.db"); > $result = $db->query("select * from table"); > $rows = $result->numRows(); Don't do that. Do:

Re: [sqlite] Problem with method numRows() in Sqlite3

2013-09-23 Thread Paolo Bolzoni
As far as I know the only way to know the number of returned rows is scanning all the query result. Isn't it? On Mon, Sep 23, 2013 at 5:48 PM, John McKown wrote: > Basically, this is telling you that there is no such function as > "Sqlite3::numRows". I did a fast

Re: [sqlite] Problem with method numRows() in Sqlite3

2013-09-23 Thread Paolo Bolzoni
You are using a binding, right? Please, can you show the problem with the plain C interface? On Mon, Sep 23, 2013 at 5:50 AM, pisey phon wrote: > Dear Sqlite Team > > > I have some problem with Sqlite3. > > > Would you mind if I want to ask you a question? > > > I got an

Re: [sqlite] Problem with method numRows() in Sqlite3

2013-09-23 Thread John McKown
Basically, this is telling you that there is no such function as "Sqlite3::numRows". I did a fast scan of the sqlite3 documentation, and there does not appear to be a sqlite3 function which returns this type of information. The PHP interface appears to just be a wrapper for PHP around existing

[sqlite] Problem with method numRows() in Sqlite3

2013-09-23 Thread pisey phon
Dear Sqlite Team I have some problem with Sqlite3. Would you mind if I want to ask you a question? I got an error "Call to undefined method SQLite3Result::numRows()". and here is my code: $db = new Sqlite3("sample.db"); $result = $db->query("select * from table"); $rows = $result->numRows();