Microsoft Access & PHP
| From: | Daniel J Owen-Mcgee | Date: | Thu, 04 Jul 2002 13:21:50 +0000 |
| Subject: | Microsoft Access & PHP | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-105433@lists.php.net to get a copy of this message | ||
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