[PHP] db design path based

Hi, I'm trying to build a new db for a website and I've got an idea on how it should work but I can't seem to figure out what the best way would be if it comes to the design of the tables in the db. Maybe I'm just looking at the the wrong way... I would like to make the website completely db

RE: [PHP] db design path based

[snip] I'm trying to build a new db for a website [/snip] Perhaps a db list would be good for this question? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] db design path based

Jay Blanchard wrote: [snip] I'm trying to build a new db for a website [/snip] Perhaps a db list would be good for this question? True, but I figured this php list would be a good place as well because it also comes down to programming problems that might occur. Also people who use php

Re: [PHP] db design path based

True, but I figured this php list would be a good place as well because it also comes down to programming problems that might occur. Also people who use php will be dealing with db's a lot as well. Jay is right. This list is supposed to answer only questions like my php code that queries a

[PHP] db design with large amount of data (?)

Hi all, i'm currently busy with db design. Since I have not worked with these amounts of content data I have a few questions. I have 2 tables: a table filled with records about products (currently 2200 records) (tblProducts) The next table is a table with pictures referring to product_ID's.

Re: [PHP] db design with large amount of data (?)

I'm no expert on massive amounts of data, but if you index the field which you are querying by (say you're relating the images to the product via productID), then I'd index the productID field of tblPics. Indexing (to the best of my limited knowledge) speeds up the querying process, and slows

[PHP] db design

hi all, I need some tips on database (mySQL) design. The problems lie in languages. I'm gonna make a e-commerce webiste. it's rather big (in my terms/experience). The website should be expandible easily with regard to languages/translations. My biggest table with product descriptions has 43

Re: [PHP] db design

this helps Andrew - Original Message - From: Wilbert Enserink [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 15, 2002 12:33 PM Subject: [PHP] db design hi all, I need some tips on database (mySQL) design. The problems lie in languages. I'm gonna make a e-commerce webiste

[PHP] RE: [PHP-DB] Design conundrum...

The problem involves 2 tables, one of editors and one of categories, both have unique ID numbers. Each editor can have authority over an arbitrary number of categories, and conversely, each category can have an arbitrary number of editors. So what is the best way to represent this in the