At 23:36 01-11-2004, Eric Cranley wrote:
I tried to find this in the archives. If I missed it, my apologies in
advance.
I'm developing an intranet for my company, and we are planning on putting
sensitive information on it. I've already setup a login system using
sessions, but I'm not sure how to ma
Eric,
Your second approach is fine. It's denormalized, extensible, and can be
manipulated using tools you put in place.
You may want to consider "groups" as well, thus people belonging to a group
could view/edit pages, that has the potential to save a lot of
administrative scut work.
A table
e time of building one from scratch and
troubleshooting it.
Good luck.
Rich
-Original Message-
From: Eric Cranley [mailto:[EMAIL PROTECTED]
Sent: Monday, November 01, 2004 5:36 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Database Design Recommendations
I tried to find this in the archives
I tried to find this in the archives. If I missed it, my apologies in
advance.
I'm developing an intranet for my company, and we are planning on putting
sensitive information on it. I've already setup a login system using
sessions, but I'm not sure how to manage and store permissions, such as who
Hi,
I'm currently working on a php-based community website for my school class.
Part of that website is a calendar function that includes the dates of all
testpapers, birthdays, school parties and so on...
Of course, a testpaper has got other properties than a birthday, so they
should go into dif
i would add a second table and also store the totals
in the lyrics table like you suggested
then you can do things like top 10 this week / top 10
this month and make sure its not being abused
LYRICS_RATINGS - id | lyric_id | rating | vote_date |
remote_addr
same idea for hits/impressions
olinu
ive a table called 'lyrics' which is the main content on my site, song
lyrics. im thinking of introducing rate this lyric and all that kind of
stuff into the site. would it be better, from a design point of view, to
create a second table for lyrics ratings and hits or just add a 'ratings'
and 'hits
Yes, songs do span shows. However, the list of songs for each weeks
show starts out as a *.asc (same a *.txt) space-separated file. This
gets uploaded via a PHP file that formats each row and inserts it into
the database. That's why even though I know there will be duplication
it appears (to me
From: "Jason Lange" <[EMAIL PROTECTED]>
> Here's my question. I'm creating a website for a weekly radio show. One
> of the items I would like to store in the database is the list of songs
> played in each show (there's normally between 20-25 songs per show), and
> the songs will be displayed by sh
Hello Everyone,
Here's my question. I'm creating a website for a weekly radio show. One
of the items I would like to store in the database is the list of songs
played in each show (there's normally between 20-25 songs per show), and
the songs will be displayed by show. Should I put all of the s
Hi,
I am creating a database for a web application. The idea for the application
is for a company administrator to be able to log into the site and allocate
staff to a project.
Staff will be able to log in and update the status of the project they are
working on and clients will be able to log in
ECTED]
Subject: [PHP-DB] Database design
Hi,
I am creating a database for a web application. The idea for the application
is for a company administrator to be able to log into the site and allocate
staff to a project which will be a clinical trial at a particular practice.
Staff will be able to log i
Hi,
I am creating a database for a web application. The idea for the application
is for a company administrator to be able to log into the site and allocate
staff to a project which will be a clinical trial at a particular practice.
Staff will be able to log in and update the status of the project
13 matches
Mail list logo
