According to the manual the second and third parameters of sqlite_open
are optional and apparantly the mode value is ignored. Out of
interest, I tried them anyway and; running via CLI fails again with;
''Call to undefined function: sqlite_open()'
But running via apache this time fails with;
Hi,
Can anyone help me turn this into a left join?
I want to get all of the records from the directors table whether matches exist
in the members table or not.
SELECT d.directorid, d.fname, d.mname, d.lname, d.title, d.suffix, d.active,
d.function,
m.id, m.directorid, m.committee,
try
SELECT
d.directorid,
d.fname,
d.mname,
d.lname,
d.title,
d.suffix,
d.active,
d.function,
m.id,
m.directorid,
m.committee,
m.position,
m.year
FROM
directors d left outer join members m
ON
d.directorid = m.directorid
WHERE
AND m.year = '2006'
ORDER BY
d.lname, d.mname,
At 20:28 31/10/2005, [EMAIL PROTECTED] wrote:
Message-ID: [EMAIL PROTECTED]
From: Keith Spiller [EMAIL PROTECTED]
To: [PHP-DB] php-db@lists.php.net
Date: Mon, 31 Oct 2005 13:29:18 -0700
MIME-Version: 1.0
Content-Type: multipart/alternative;
It's not aware of function sqlite_query() So you need to define what it is.
There is alot of docs for fixes/workarounds for this online in sqlite docs.
Eoin Hennessy [EMAIL PROTECTED] wrote:Ahh, I'm not very familiar with php,
should have looked into the
effects of the '@' symbol. Once
yes
From: Ron Piggott [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB] ini_set / $_SESSION[''] file directory
Date: Sun, 30 Oct 2005 01:58:42 -0500
Is there a way that I may specify the directory (perhaps with the
ini_set command) where the