BETWEEN sql query

[benji87]

Can someone please correct me where im going wrong here please?

 

This is my code for trying to pull results that have a event date between two dates:

 

<?
include "db.php";

$act_type = 'All';
$area = 'Portsmouth';
$start = '01/01/2008';
$end = '30/05/2008';

$query = mysql_query("SELECT * FROM events WHERE date BETWEEN '$start' AND '$end'");
while ($data = mysql_fetch_array($query))
{
?>
<table width="100%" border="0" cellpadding="2" cellspacing="2">
  <tr>
    <td width="33%" bgcolor="#efefef"><?=$data["event"]?></td>
    <td width="47%" bgcolor="#efefef"><?=$data["date"]?></td>
  </tr>
</table>
<?
}
?>

 

For some reason it returns all records in the table rather than just the ones between the two dates.

 

Thanks

[adam291086]

some database treate the BETWEEN ....AND.. differently.

 

Some database will do what your asking for and others will do the opposite. I.E. display all records that are not between those dates.

 

Check your result echoed back and see if the opposite of what you want is happening

[pdkv2]

i have faced the similar problem

 

it was due to the date field in the database was using '2008-12-30' format and we are trying to compare it with '30-12-2008'

 

Rgds

Sharad

[benji87]

In my case its just showing all the records in the table including the ones inside and out the dates ive specified.

 

My field isn't setup as a date field. Its setup as a varchar. Would that affect it do you think?

[Nhoj]

More than likely... Try setting the field to a date field...

 

Edit: ..Also make sure all your date's are formatted correctly..