I am building a database with permissions for different modules. The
permissions table contains a separate row for each module/user combination, and
lists the add/mod/del permissions for that module. So, for example, user 'bob'
might have add and del rights for 'module1', add only rights for
On Fri, 17 Sep 2004 11:33:04 -0700 (PDT), David T. [EMAIL PROTECTED] wrote:
I am building a database with permissions for different modules. The
permissions table contains a separate row for each module/user combination,
You didn't say, but if you're using PHP you might find this of use:
- Original Message -
From: David T. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 17, 2004 2:33 PM
Subject: Problems with Left Join query
I am building a database with permissions for different modules. The
permissions table contains a separate row for each module
First, you want to get an answer for every module, so you must use
modules LEFT JOIN permissions
to get a row for every module. You see? The table with missing rows (no
row for Bob/module3 in permissions) goes on the right.
When the table on the right does not have a matching row, the LEFT
I'm trying to write a polling application and display the results on an
admin screen.. my goal is to show all the answers for the poll questions and
display the # of votes for each. The query I have to do this is:
select pd.ANSWER_TEXT, pr.*, COUNT(*) as NUM from ft_pollresponses as pr
right
, February 13, 2002 3:35 PM
To: mysql
Subject: Problems with a join...
I'm trying to write a polling application and display the results on an
admin screen.. my goal is to show all the answers for the poll questions and
display the # of votes for each. The query I have to do this is:
select
