Re: [PHP-DB] When does using multiple tables make sense?

2008-10-26 Thread Lester Caine
Liam Friel wrote: 2008/10/20 Lester Caine [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Jason Pruim wrote: So my question is... When is it best to use more tables? All the info will be related to each other, so I think I would be looking at either a many-to-many

Re: [PHP-DB] When does using multiple tables make sense?

2008-10-20 Thread TG
] When does using multiple tables make sense? Good morning everyone! Hope you all have your coffee in hand when reading this :) In case it makes a difference, It will be written in PHP 5.2.6 and using mysql 5.0.51a-community with apache 2.2.9. I am in the planning stages of a project

Re: [PHP-DB] When does using multiple tables make sense?

2008-10-20 Thread Bastien Koert
On Mon, Oct 20, 2008 at 7:59 AM, Jason Pruim [EMAIL PROTECTED] wrote: Good morning everyone! [snip][/snip] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php I would suggest breaking the client and contacts into two tables. Its likely

Re: [PHP-DB] When does using multiple tables make sense?

2008-10-20 Thread Lester Caine
Jason Pruim wrote: So my question is... When is it best to use more tables? All the info will be related to each other, so I think I would be looking at either a many-to-many relationship, or a many-to-one relationship (still figuring that out). One thing that I've realised make sense is to