[Charliezak]

Hi, im trying to get a date range Between anydate to anydate,

my date format is dd.mm.yyyy


this is the table

CREATE TABLE table (
id int(11) unsigned NOT NULL auto_increment,
custid varchar(11) NOT NULL default '',
note text NOT NULL,
date varchar(10) NOT NULL default '',
datefu varchar(10) NOT NULL default '',
PRIMARY KEY (id)
) TYPE = MyISAM;

is it basicly
SELECT * FROM $tablename WHERE datefu BETWEEN DATE $datefa AND DATE $datefb