Preserved Topic: Need help with complex SELECT statement via PHP (Page 1 of 1)

Here is what I am doing.

I am using a mysql database to log each time a user uses a section on my website.

So, for each time a user enters a certain seciton on the website, a record is created in the database. It stores the user's name, the account number that the user is a part of, and a 0 or 1 flag to determine if a user took advantage of the feature.

Lets say, for instance, there are 2 sections.

For the 4 users of account number 15, they collectivley go to section one 3 times and section two 4 times.
Account number 14 goes to section number one 1 time and section number two 1 time.
Account number 12 goes went to section number one 0 times and section number two 1 time.

The mySQL table (records) will have 10 records similar to the following:

<BLOCKQUOTE><FONT face="Verdana, Arial">code:</font><HR><pre>
------------------------------------

acidbox: My first feeling is that things would be easier with a different DB structure. For the table that logs these things I'd go with something like:

<BLOCKQUOTE><FONT face="Verdana, Arial">code:</font><HR><pre>
user_id

that is a really good idea. I'll have to try it. Thanks for the heads up!

acidbox: I was tired when I wrote that but it seems OK if a little brief. Have a go and get back to us if you have any problems - the SQL does get a bit more complex but its not rocket science

___________________
Emps

FAQs: Emperor

The SQL for this isn't too complex...

SELECT acct_num, sum(sec_1), sum(sec_2) FROM records GROUP BY acct_num

well damn. That was even easier.. lol...thanks stinx.

SQL is your friend!

Rahly