Count in function does not work WHY ?

[P Farrell]

Simple..the table has groups with a number of properties each with a date for every day of the year

This statement works fine

SELECT count(*)
FROM allbookings
where ( bookingdate between '2014-06-13' and '2014-06-20'
and groupid='LP4253'
and propid=9 ) ;

The answer is 8

when I put this in a function the answer is 336 !!


CREATE DEFINER=`XXXXXXXXXXX`@`%` FUNCTION `getrpropertycount`
(groupid varchar(45),
propid INT,
startdate Date,
enddate Date
) RETURNS int(11)
BEGIN
DECLARE pcount INT ;
set pcount=0;

SELECT count(*) into pcount
FROM allbookings
where
( bookingdate between '2014-06-13' and '2014-06-20'
and groupid='LP4253'
and propid=9 ) ;


RETURN pcount;

END



I checked this is the same as

SELECT count(*)
FROM allbookings
where ( bookingdate between '2014-06-13' and '2014-06-20') ;

ie every time I use a date comparisson ALL the other statements are ignored

Why ?.. what stupid mistake am I making