multiple counts and joints

[harpic]

Hi everybody

I am using MySQL 5 with php 5.
I am trying to do the following

"SELECT [usertable].*, [accesslevelinfo].*, COUNT([visitstable.field]) AS visitcounter, COUNT([downloadstable.field]) AS downloadcounter FROM [usertable] LEFT JOIN [accesslevelinfo] ON [accesslevelinfo.field] = [usertable.field] LEFT JOIN [downloadstable] ON [downloadstable.field] = [usertable.field] AND [downloadstable.datefield] >= '".[datevariable]."' AND [downloadstable.datefield] <= '".[datevariable]."' LEFT JOIN [visitstable] ON ([visitstable.field = [usertable.field] AND ([visitstable.datefield] >= '".[datevariable]."' AND [visitstable.datefield] <= '".[datevariable]."')) [wherestatement] GROUP BY [usertable.field]

I know that this does not work and probably makes no sense but I am trying to get a users access level, number of visits, number of downloads and then more info after that for a repor -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[nchammer]

mysql does not allow square brackets like that, and [wherestatement] is definitely weird

would you mind showing your CREATE TABLE statements please?
you definately lack in basics mate
sorry, but that's true -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --