Re: Microsoft Access & PHP
| From: | George Pitcher | Date: | Thu, 04 Jul 2002 13:31:13 +0000 |
| Subject: | Re: Microsoft Access & PHP | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20318@lists.php.net to get a copy of this message | ||
Just a thought.
Try putting quotes around the 'True'.
George (no expert - not even a novice - yet)
----- Original Message -----
From: "Daniel J Owen-Mcgee" <D.J.Owen-Mcgee@derby.ac.uk>
To: <php-db@lists.php.net>
Sent: Thursday, July 04, 2002 2:29 PM
Subject: [PHP-DB] Microsoft Access & PHP
Hi,
I'm gleaning microsoft SQL from queries within a MS Access database, for
insertion into my PHP pages. This has been working fine but the example
below just refuses to work,
SELECT ExamPapers.EPaperID, ExamPapers.EPapersText, ExamPapers.[Title of
Paper], ExamPapers.Course, ExamPapers.School, ExamPapers.Year,
ExamPapers.[Jan/Summer], ExamPapers.[Module Code], ExamPapers.Stage,
ExamPapers.[Storage Location], ExamPapers.[Add to Webpage]
FROM ExamPapers
WHERE (((ExamPapers.School)="Colour and Imaging Institute") AND
((ExamPapers.[Add to Webpage])=True));
I want to pull records from 1 table (ExamPapers).
The WHERE line is causing problems i.e if I remove it, my php pages actually
show. Can anyone see what I'm doing wrong?
Thanks,
Daniel Owen-McGee
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php