SELECT B.Title FROM phpCalendar_Details AS B, phpCalendar_Daily AS A
WHERE A.CalendarDetailsID = B.CalendarDetailsID AND CURDATE( ) BETWEEN
A.StartDate AND A.StopDate
Also, you don't need to use the backticks around field names unless they contain
spaces or other reserved words and characte
A.StopDate
-Original Message-
From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 04, 2003 1:36 PM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: Re: [PHP-DB] A little JOIN help please...
> SELECT 'A.Title'
> FROM `phpCalendar_Dail
> SELECT 'A.Title'
> FROM `phpCalendar_Daily` AS 'B'
> JOIN 'phpCalendar_Details' AS 'A' ON 'A.CalendarDetailsID' =
> 'B.CalendarDetailsID'
> WHERE CURDATE( )
> BETWEEN 'B.StartDate' AND 'B.StopDate'
Take out all of those quotes! You're making strings out of everything.
WHERE CURDATE() BETWEEN '