Fantastic! This was indeed the problem and has solved it. Many thanks!
On Tue, 24 Feb 2004 13:14:51 +0100, Jigal van Hemert wrote:
>> $sql = 'SELECT Username, Count( Username ) FROM MainDetails, Usernames
>> WHERE MainDetails.UserID = Usernames.UserID and Date Between \'$Date1\'
>> and \'$Date2\
Hello All,
I have a very strange problem which makes no sense to me whatsoever.
I am trying to find the number of queries that the people have dealt with
in a database between two dates. The dates are generated from some drop
down boxes and dropped into a variable. This is the code for the query.