how to query rows between some date ???

[sys7em]

Hi all...

I want to select all rows ...which are between one date for example

$query = "select * from kontragenti where data1>2004-01-01 and data1<2004-12-31";
$result = mysql_query($query);
if (!$result) echo 'Query could not be done!';
else {
	while ( $row = mysql_fetch_array($result)) {
///////// 
            echo("$row[0] , $row[1], $row[2], $row[3], $row[4]"); 
            echo("<br>"); 

  }
  }

But none of this works ...
I want to dispaly all rows which date1 are between 01.01 nad 31.12 ..but no luck
How should I fix this ..?

P.S. The date1 column type is date in the format 0000-00-00

[devinemke]

SELECT * FROM kontragenti WHERE date1 BETWEEN '2004-01-01' AND '2004-12-31'

however you query suggests that you simply want all records from 2004 in which case you could do:

SELECT * FROM kontragenti WHERE YEAR(date1) = '2004'

[sys7em]

Thanks a lot 🙂