[SOLVED] Select data from a date range

[nbarone]

I have some data I want to query between dates. In the MySql database, they have a datetime field (Y-m-d h:i:s)

 

How can I effectivily query a range of date

like: SELECT * FROM table WHERE tb_date < "2009-01-01" AND tb_date > "2009-06-01"

 

[J.Daniels]

Have you tested that statement?  The syntax looks correct, however, your conditionals would return anything outside of the date range you specified.

[rhodesa]

yeah...you just have to switch the > and <:

SELECT * FROM table WHERE tb_date > '2009-01-01' AND tb_date < '2009-06-01'

or use a BETWEEN:

SELECT * FROM table WHERE tb_date BETWEEN '2009-01-01' AND '2009-06-01'

[nbarone]

here's what I got:

<?php
function getNumRows($qry){
		if($qry <> NULL){
			$qry = "SELECT * FROM epostcard WHERE ".$qry;
		} else {
			$qry = "SELECT * FROM epostcard";
		}
   		$result = mysql_query($qry);
		$numRows = mysql_num_rows($result);
		unset($qry,$result);
		return $numRows;
	}

$totalPostcards = getNumRows("p_pcSentDate <= '". $dateStart . "' AND p_pcSentDate >= '" . $dateEnd . "'");

 

this returns 0 rows. (incorrect)

 

$totalPostcards = getNumRows("p_pcSentDate BETWEEN '". $dateStart . "' AND '" . $dateEnd . "'");

 

this returns the correct rows, however I need to get the rows that are on dateStart and dateEnd - this does the rows BETWEEN (obv),

[Daniel0]

Switch your end and start dates. You're selecting the rows outside that date range.

[rhodesa]

You are still doing <= START and >= END. The date can't be both before a start date and after an end date. you want after a start date and before and end date:

$totalPostcards = getNumRows("p_pcSentDate >= '". $dateStart . "' AND p_pcSentDate <= '" . $dateEnd . "'");

[nbarone]

I give you both the right to eSlap me. it's been a long day....

 

thank you.