Re: [sqlite] Retrieving column names

2010-02-27 Thread Kees Nuyt
On Sat, 27 Feb 2010 13:46:28 -0500, "ve3meo" wrote: >Is there a way to use SELECT against the PRAGMA result-set? > >This returns an error: >SELECT * FROM (PRAGMA table_info(tablename)); With the command line tool, you can: sqlite> create table pti( ...>

Re: [sqlite] Retrieving column names

2010-02-27 Thread Matthew Smith
Of ve3meo Sent: Sunday, 28 February 2010 05:46 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Retrieving column names "P Kishor" <punk.k...@gmail.com> wrote in message news:cdf6db501002270448s2d28ef4fm9a831fdfa7bf3...@mail.gmail.com... > On Sat, Feb 27, 2010 at 6:43 AM, Pet

Re: [sqlite] Retrieving column names

2010-02-27 Thread ve3meo
"P Kishor" wrote in message news:cdf6db501002270448s2d28ef4fm9a831fdfa7bf3...@mail.gmail.com... > On Sat, Feb 27, 2010 at 6:43 AM, Peter Rodwell > wrote: >> I'm sure this question has been asked and answered a million times, but >> I've not been able

Re: [sqlite] Retrieving column names

2010-02-27 Thread P Kishor
On Sat, Feb 27, 2010 at 6:43 AM, Peter Rodwell wrote: > I'm sure this question has been asked and answered a million times, but I've > not been able > to find the answer. Googling for it has turned up lots of answers, none of > which seem to > work with SQLite:

[sqlite] Retrieving column names

2010-02-27 Thread Peter Rodwell
I'm sure this question has been asked and answered a million times, but I've not been able to find the answer. Googling for it has turned up lots of answers, none of which seem to work with SQLite: Given the SQLite databse "mydb" containing table "mytable", what is the correct SQL command to

Re: [sqlite] Retrieving column names?

2008-02-04 Thread Kees Nuyt
On Mon, 04 Feb 2008 10:46:53 +0100, Gilles <[EMAIL PROTECTED]> wrote: >Hello > > I'd like to display the column names as headers in an HTML table. > > 1. I need to retrieve the column names, but the following doesn't work: > > # cat cols.php > $dbh = new > PDO("sqlite:db.sqlite"); > >

[sqlite] Retrieving column names?

2008-02-04 Thread Gilles
Hello I'd like to display the column names as headers in an HTML table. 1. I need to retrieve the column names, but the following doesn't work: # cat cols.php exec($sql); $sql = "SELECT * FROM customer"; $row = $dbh->query($sql)->fetch(); foreach ($row as $col) {