Getting Familiar With Site Checklist
Posted: Fri Jun 20, 2008 1:48 pm
Hello,
I want to create script for my site that makes a user go through a checklist of things.
This checklist would have its own page and would list everything they must do and what they havn't yet done.
The user must do the entire list. If he/she doesn't, there is a banner that would display on all the pages until the new member would complete it. Once completed, the banner would disappear. This is so they get familiar with most features of the site.
Anyways, my question is, how can I organise my tables in my sql database? I don't want multiple entries per user, but I also want the script to run and check what they have and what they havn't done all together but no use too many queries.
I did think of making it complete a row for every task a user does, but when you go to check what tasks have been done, it may have to check through many entries, and make multiple searches.
Any ideas?
Thanks!
Seb
I want to create script for my site that makes a user go through a checklist of things.
This checklist would have its own page and would list everything they must do and what they havn't yet done.
The user must do the entire list. If he/she doesn't, there is a banner that would display on all the pages until the new member would complete it. Once completed, the banner would disappear. This is so they get familiar with most features of the site.
Anyways, my question is, how can I organise my tables in my sql database? I don't want multiple entries per user, but I also want the script to run and check what they have and what they havn't done all together but no use too many queries.
I did think of making it complete a row for every task a user does, but when you go to check what tasks have been done, it may have to check through many entries, and make multiple searches.
Any ideas?
Thanks!
Seb