SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member Aber_Al's Avatar
    Join Date
    Dec 2004
    Location
    Wales
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Ignore this post - wrong forum woops sorry

    Hi,

    OK so i'll throw my hands up and admit- i'm somewhat a newbie in the practicalities of mysql (relationships and normal form, on the other hand, are no probs).

    I've been trying to design a database where a property table holds an entry for a property that is for sale and there is one field "user-id" that I want to link to the user table so that when they select the property from the list of displayed properties I can query both tables in order to get info regarding the seller and the property.

    It's a 1:many relationship (user: property) and I was wondering this...

    I was going to have the "user-id" in the property table as a FK relating to the "user" table. However I've also seen that "..JOIN" statements exist and I was wondering which is the best method to use? If I use the FK do i still need to create the query with a 'join' syntax?

    Cheers guys,

    Al.
    Last edited by Aber_Al; Jan 4, 2005 at 13:18. Reason: got a smiley face when doin : p with no space :S

  2. #2

  3. #3
    SitePoint Member Aber_Al's Avatar
    Join Date
    Dec 2004
    Location
    Wales
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Oh what a bleedin smeg head I am (sorry mr admin)

    BIG Sorry guys!

    Nuts sorry hadn't realised i'd posted in php eek

    Al.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •