Microsoft Access & PHP - Solved

From: 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

« previous php.general (#105455) next »