[SOLVED] MySQL Between....

[suttercain]

Hi guys,

 

I am trying to select BETWEEN two dates:

 

<?php
$date1 = mysql_real_escape_string($_GET['input9']);
$date2 = mysql_real_escape_string($_GET['input10']);
echo $date1 ." & ". $date2;
$query = mysql_query("SELECT * FROM canada WHERE letter_requested BETWEEN $date1 AND $date2") or die (mysql_error());
while($row = mysql_fetch_array($query)) {
echo $row['first_name'];
}
?>

 

I am not getting any out put. But if I run just "SELECT * FROM canada" I do get the out put. Am i using the BETWEEN correctly?

 

Thanks.

[Barand]

You need to put $date1 and $date2 in single quotes.

 

What format are your dates, and "letter_requested"?

[suttercain]

They are in typical MySQL date format YYYY-MM-DD

[suttercain]

that worked Barrand. Thanks!