RE: [PHP-DB] A little JOIN help please...
| From: | Adam Royle | Date: | Wed, 05 Feb 2003 02:41:23 +0000 |
| Subject: | RE: [PHP-DB] A little JOIN help please... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25443@lists.php.net to get a copy of this message | ||
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 characters.
Adam