[PHP] Microsoft Access & PHP - Solved

2002-07-04 Thread Daniel J Owen-Mcgee
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 w

[PHP] Microsoft Access & PHP

2002-07-04 Thread Daniel J Owen-Mcgee
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.Schoo