Skip to main content
N
noa2
Participant
November 11, 2008
Question

coldfusion script for linking tables in database

  • November 11, 2008
  • 3 replies
  • 435 views
I need help in making a script which make images in database images to be link to: 1. another table fields. 2. another images.
please tell me how i can do it ?
    This topic has been closed for replies.

    3 replies

    A
    Anonymous
    November 17, 2008
    With all due respect, your message for help is confusing.

    BUT, like people have said, it sounds like you need to learn how to join some tables together on columns that share the same data...like a unique ID. "One to many" meaning one row in table "A" can join to many rows in another table "B".

    Ben Fortas book "SQL in ten minutes" is priceless!

    Mikey.
    D
    Dan_Bracuk
    Inspiring
    November 15, 2008
    Sounds like a many to many relationship. If you don't know what that means, I've heard good things about the book, "Database Design for Mere Mortals".
    W
    wbnc1902
    Participating Frequently
    November 11, 2008
    I am not 100% sure I know what you are asking but, I think you are asking about linking two tables together. That can be done a few different ways using SQL. If you could describe what you are attempting to do in a bit more detail I am sure I, or someone, can help you with the SQL you will need.

    Sorry I can't be more help.
    N
    noa2Author
    Participant
    November 15, 2008
    it goes like this:
    image product 1 image2 product-a product-a1 image3 image4
    product-a2 image3 image4
    product-a3 image3 image4
    image2 product-b
    image2 product-c
    image product 2 image2 product-2a
    image product 3 image2 product-3a

    explanation: the "image product 1" is link to: "image2 product-a
    image2 product-b
    image2 product-c"

    the "image2 product-a" is link to "product-a1 image3 image4
    product-a2 image3 image4
    product-a3 image3 image4"

    the "image product 2" is link to "image2 product-2a" etc.
    the "image 3" and "image 4" are link to big images.
    can you help me ?
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices