Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //query the database for events between the first date of the month and the last of date of month
- $q = "SELECT
- nr,
- DATE_FORMAT(Date1,'%d') AS day_start,
- DATE_FORMAT(Date2,'%d') AS day_end,
- Date1,
- Date2,
- description,
- title,
- Variabele3 as locatie,
- Variabele4 as internet,
- Variabele5 as inlichtingen,
- Variabele6 as tel
- FROM vw_activeContent
- WHERE Date1 BETWEEN '$current_year-$current_month-01'
- AND '$current_year-$current_month-$total_days_of_current_month'
- order by Date1
- ";
- $result = mysql_query($q);
Add Comment
Please, Sign In to add comment