Microsoft Access & PHP - Solved
| From: | Daniel J Owen-Mcgee | Date: | Thu, 04 Jul 2002 14:58:46 +0000 |
| Subject: | Microsoft Access & PHP - Solved | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-105455@lists.php.net to get a copy of this message | ||
Hi All,
My query (below) has been solved. Thanks to all who responded so quickly!
Putting single quote marks around 'Colour and Imaging Institute' did the trick.
DAniel
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