I want to use a MySQL JOIN function but it does not work when i try to do it. This is what i have:

'SELECT users.*, COUNT(messages.messageid) AS messages_count, COUNT(messages.messageid)-SUM(messages.is_read) AS unread_messages, COUNT(events.eventid) AS events_count, COUNT(events.eventid)-SUM(event.is_read) AS unread_events FROM uploader_users AS users LEFT JOIN uploader_messages AS messages USING(userid) LEFT JOIN uploader_events AS events USING(userid) WHERE users.userid=%d AND users.password=\'%s\' GROUP BY users.userid ;'

But it does not work correctly, can some one help me. Dont say Google because i have looked through many manuals and tutorials.

Thanks in advance.

What happens? Do you get an error, an empty result set, or something else...?

i get an empty result, but no errors.

Are you calling this from PHP? Do you have access to the mysql utility or phpmyadmin where you can run the query and see the results?

Yes but i want to use the USING(userid) from 1 location not both.