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(
...>
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
"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
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:
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
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");
>
>
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) {
7 matches
Mail list logo