 |
POETRY NEAR YOU |
|
|
|
April 2008 |
|
| S |
M |
T |
W |
T |
F |
S |
| | | 1 |
2 |
3 |
4 |
5 |
| 6 |
7 |
8 |
9 |
10 |
11 |
12 |
| 13 |
14 |
15 |
16 |
17 |
18 |
19 |
| 20 |
21 |
22 |
23 |
24 |
25 |
26 |
| 27 |
28 |
29 |
30 |
|
|
|
|
|
|
|
|
|
|
|
|
MySQL Query Error: Unknown table 'page' in where clause
Query: SELECT *, DATE_FORMAT(dtmEventDate, "%M %e, %Y") as startDate, DATE_FORMAT(dtmToDate,"%M %e, %Y") as endDate FROM Events WHERE bitPublish = 1 AND MONTH(dtmEventDate) = 4 AND YEAR(dtmEventDate) = 2008 AND DAYOFMONTH(dtmEventDate) <= page.php and DAYOFMONTH(dtmToDate) >= page.php or (DAYOFMONTH(dtmEventDate) = page.php and MONTH(dtmEventDate) = 4) AND dtmEventDate >= CURDATE() AND dtmEventDate <= DATE_ADD(CURDATE(),INTERVAL 1 YEAR) and bitPublish = 1 ORDER BY dtmEventDate, strEventTitle | |
