Re: Microsoft Access & PHP
| From: | Latex Master | Date: | Thu, 04 Jul 2002 13:27:45 +0000 |
| Subject: | Re: Microsoft Access & PHP | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-105436@lists.php.net to get a copy of this message | ||
Hello Daniel,
Try to use a query line like below:
WHERE (((ExamPapers.School)=\"Colour and Imaging Institute\") AND ((ExamPapers.[Add to
Webpage])=True));
And let us know it it will work
Thursday, July 4, 2002, 5:21:50 PM, you wrote:
DJOM> Hi,
DJOM> I'm gleaning microsoft SQL from queries within a MS Access database, for insertion
DJOM> into my PHP pages. This has been working fine but the example below just refuses to work,
DJOM> SELECT ExamPapers.EPaperID, ExamPapers.EPapersText, ExamPapers.[Title of Paper],
DJOM> ExamPapers.Course, ExamPapers.School, ExamPapers.Year, ExamPapers.[Jan/Summer], ExamPapers.[Module
DJOM> Code],
DJOM> ExamPapers.Stage, ExamPapers.[Storage Location], ExamPapers.[Add to Webpage]
DJOM> FROM ExamPapers
DJOM> WHERE (((ExamPapers.School)="Colour and Imaging Institute") AND ((ExamPapers.[Add
DJOM> to Webpage])=True));
DJOM> I want to pull records from 1 table (ExamPapers).
DJOM> The WHERE line is causing problems i.e if I remove it, my php pages actually show. Can
DJOM> anyone see what I'm doing wrong?
DJOM> Thanks,
DJOM> Daniel Owen-McGee
--
Best regards,
Latex mailto:freeman@submission.org.ru