RE: [PHP-DB] A little JOIN help please...
| From: | SBCSI) | Date: | Tue, 04 Feb 2003 19:48:30 +0000 |
| Subject: | RE: [PHP-DB] A little JOIN help please... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25435@lists.php.net to get a copy of this message | ||
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:holmes072000@charter.net]
Sent: Tuesday, February 04, 2003 1:36 PM
To: NIPP, SCOTT V (SBCSI); php-db@lists.php.net
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...