subject:"\[PHP\-DB\] Re\: PHP\/Access problem"

Re: [PHP-DB] Re: PHP/Access problem

2002-03-27 Thread George Pitcher

02 10:03 PM Subject: [PHP-DB] Re: PHP/Access problem SELECT * FROM 'Documents'WHERE (CourseRef='4712' AND Valid_From<=#26/03/2002# AND Valid_Until>=#26/03/2002#) Order by Author,Title should be SELECT * FROM Documents WHERE (CourseRef='4712' AND Valid_From<

[PHP-DB] Re: PHP/Access problem

2002-03-26 Thread Adam Royle

SELECT * FROM 'Documents'WHERE (CourseRef='4712' AND Valid_From<=#26/03/2002# AND Valid_Until>=#26/03/2002#) Order by Author,Title should be SELECT * FROM Documents WHERE (CourseRef='4712' AND Valid_From<=#26/03/2002# AND Valid_Until>=#26/03/2002#) Order by Author,Title your table name shoul