PHP and MySQL BETWEEN dates with different years

I have a database which holds a bunch of events. Each event has a start date and an end date, so they should only show on the site when the date chosen falls between those dates.

I thought it made sense to make use of the SQL BETWEEN statement, but it does not work.

When a user chooses a year and month, I assign php vars and run the query.

Here's the query:

SELECT * FROM table WHERE $year BETWEEN YEAR(Start) AND YEAR(End) AND $month BETWEEN MONTH(Start) AND MONTH(End)

Any ideas or suggestions how to do this?

View Answers

Ads

Advertisements

days between two given dates using PHP
days between two given dates using PHP How can we know the number of days between two given dates using PHP? Hi friends, Example... dates. </title> </head> <body> <?php

How to select Data Between Two dates in Java, MySQL
How to select Data Between Two dates in Java, MySQL How to select Data Between Two dates in Java, MySQL? Thanks in advance. http://www.v7n.com/forums/coding-forum/294668-how-select-data-between-two-dates-php

range of dates in mysql query
range of dates in mysql query How to select the range of dates in mysql ..when i have to select from between & and of date function? SELECT * FROM MAAccounts WHERE updatedOn BETWEEN ? AND ? ORDER

Different between getRequestParameterMap() and getRequestParameterValuesMap()
Different between getRequestParameterMap() and getRequestParameterValuesMap() What is the different between getRequestParameterMap() and getRequestParameterValuesMap

calculate difference between two dates
calculate difference between two dates hi, I was actually working on to calculate the number of days between two dates of dd/mm/yyyy format... the difference between the two dates

PHP Mysql Group By
PHP Mysql Group By PHP Mysql Group By is used to establish a relation between the PHP... The Tutorial illustrate an example from PHP Mysql Group By. To understand and grasp

PHP Mysql Database Connection
PHP Mysql Database Connection PHP Mysql Database Connection is used to build a connection between the PHP on the server-side and Mysql on the backend. Understand with Example

How to use between in mysql.
How to use between in mysql. I want to display records inbetween two dates and also want to use where condition( like and deptname='Pediatry... WHERE column_name BETWEEN value1 AND value2 Here is an example, we have a table

php mysql
php mysql automatically insert a value in the month field at the last date of current month in mysql database

PHP search data with different format
PHP search data with different format How to search data with different format in PHP

Upgrading a PHP/MYSQL application?
Upgrading a PHP/MYSQL application? Upgrading a PHP/MYSQL application

mysql difference between two numbers
mysql difference between two numbers How to get total bate difference between two dates for example 1/01/2012 and 1/02/2012 in MYSQL? ..., '01/02/2012', 103)) DATEDIFF() in MYSQL always returns the difference

PHP and MySQL Work Well Together
PHP and MySQL are open source programs that are very different from each other... and MySQL together. These can work with many different kinds of modules. These include... important for anyone to use. The first thing to know is that the PHP script can work

list of all months between two dates in java
list of all months between two dates in java Hi, I want to get list of all months with year between two dates. How to do this in Java? Thanks Hi, This is the example code which can be used: package test.app

PHP MYSQL Interview Questions
PHP MYSQL Interview Questions What kind of questions can be asked in an PHP, MYSQL interview? Can anyone post the PHP interviews questions with well explained answers? PHP, MYSQL Interview Questions Please tell me

JavaScript check if date is between two dates.
JavaScript check if date is between two dates. Check if date is between two dates? <html> <head> <title>Date before... it is lying between dates or not.Date.parse() is used to convert

Upgrading databases between MySQL 5.0 to MySQL 5.5
Upgrading databases between MySQL 5.0 to MySQL 5.5 Upgrading databases between MySQL 5.0 to MySQL 5.5

Different tables present in MySQL
Different tables present in MySQL What are the different tables present in MySQL? Which type of table is generated when we are creating a table.... Merge 4. INNO DB 5. ISAM MyISAM is the default storage engine as of MySQL 3.23.

Hi .Difference between two Dates - Java Beginners
Hi .Difference between two Dates Hi Friend.... Thanks for ur Very good response.. Can u plz guide me the following Program.... difference between two dates.. I need to display the number of days by Each Month

php form post to mysql
php form post to mysql How to post data into mysql database from the PHP post data form

Mysql Time Difference Function
difference between any two dates. Understand with Example The Tutorial describe... the time difference between any two consecutive dates. TimeDiff('Year1 Time1... Mysql Time Difference Function

PHP MySQL query
PHP MySQL query I have 11 tables and have to do the CRUD operations keeping userid as a reference key

php inserting date into mysql
php inserting date into mysql php inserting date into mysql Here is a php code that inserts date into mysql database. In the given code, data is a database table. <?php table $query_manual = "INSERT INTO data

Javascript calculate number of days between two dates
Javascript calculate number of days between two dates In this tutorial, you will learn how to calculate number of days between two dates.For this, you need... using Date.getTime() function. Once both Dates have been converted, subtracting

drop down php mysql - PHP
drop down php mysql PHP Script required to show the similar drop down item in each menu without refreshing the page. Is it possible if yes how

Import MYSQL file in PHP - PHP
Import MYSQL file in PHP i wanted to import the mysql file in PHP5 on button click. is it possible to do it? Is there any possibility of data security

php mysql fetch array example
php mysql fetch array example How to fetch data from mysql and store it into an array in PHP? Please post an example. Thanks in Advance

Ads