PHP: date between date

php sql date between
Karem picture Karem · Nov 17, 2010 · Viewed 8.8k times · Source

I have two dates:

10-11-2010 and 17-11-2010

Now i would like to SELECT all rows with the dates between those two.

How can I do that?

Answer

Haim Evgi picture Haim Evgi · Nov 17, 2010

its very simple using between in where clause , read more

select * from mytable where date between '10-11-2010' and '17-11-2010'

Related questions

PHP check if date is 30 days in the past

I'm having a bit of a problem here. I insert a date into the database: date_last_applied. I can just call this by using $row['date_last_applied'], of course. Now, I need to check if this inserted date …

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More
MySQL query String contains

I've been trying to figure out how I can make a query with MySQL that checks if the value (string $haystack ) in a certain column contains certain data (string $needle), like this: mysql_query(" SELECT * FROM `table` WHERE `column`.contains(…

Read More