Database Design

•

What is DaniWeb IT Discussion Community?

You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 397,646 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,378 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our PHP advertiser: Lunarpages PHP Web Hosting

Database Design

•

Join Date: Oct 2004

Location: Singapore

Posts: 7

Reputation: qazs is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

qazs

Offline

Newbie Poster

Database Design

Nov 20th, 2004

Hi,
I'm looking for some advice regarding creating a well-designed database site.
The scenario is this:
I have a main database that holds all my users' data,
I'll call it UserData.
Now I want to make a sort of Search By Category form, which will
output those users from UserData which meet the criteria.

Ive thought of 2 ways to do this:
1. Create a new table. Then connect to UserData,
grab the necessary info and dump them into the new table.
Then the user can manipulate this new table.
Connection to UserData is closed.

2. Connect to UserData everytime something is performed, like search or sort etc.

So which do you think is a better way? Thanks for any advice.