Re: A little JOIN help please...
| From: | 1LT John W. Holmes | Date: | Tue, 04 Feb 2003 19:35:32 +0000 |
| Subject: | Re: A little JOIN help please... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25434@lists.php.net to get a copy of this message | ||
> 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...