Results 1 to 3 of 3
Jan 4, 2005, 11:58 #1
Ignore this post - wrong forum woops sorry
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?
Last edited by Aber_Al; Jan 4, 2005 at 12:18. Reason: got a smiley face when doin : p with no space :S
Jan 4, 2005, 12:02 #2
- Join Date
- Oct 2003
- 0 Post(s)
- 0 Thread(s)
Jan 4, 2005, 12:06 #3
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