[thelist] Mysql/PHP Searching WAS: Sql join problem

[partyarmy]

multiple records are found in the profile table, with a single
member_id. one for each profile category the user has filled in. so a
one-to-many i suppose.


On Fri, 10 Dec 2004 14:57:28 -0400, Sarah Sweeney
<mr.sanders at designshift.com> wrote:
> > I have two tables, one is a members table which holds personal
> > information about users registered on my site. The other table is a
> > profile table which conatins the registered users profile data.
> 
> Are these tables related in a one-to-many relationship, or a one-to-one
> relationship? I.E. does each record in the Members table have several
> corresponding records in the Profiles table, or just one?
> 
> 
> 
> --
> Sarah Sweeney  ::  Web Developer & Programmer
> Portfolio  ::  http://sarah.designshift.com
> Blog  ::  http://hardedge.ca
> --
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>