Thanks... I was able to figure it out using what my book calls the old method. Here is what ended up working for me:
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 -----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_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 'string' AND 'anotherstring' etc... ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
