WEB mysql is killing me. - new to mysql (Update Query w/ Join)

Discussion in 'OT Technology' started by LyFeWoRx, Jan 23, 2008.

  1. LyFeWoRx

    LyFeWoRx 2 + 2 = 4 OT Supporter

    Joined:
    Jul 17, 2006
    Messages:
    120
    Likes Received:
    0
    Location:
    New York, New York
    UPDATE From products as p
    LEFT JOIN products_description as pd
    ON p.products_id = pd.products_id
    SET pd.products_head_title_tag = pd.products_head_title_tag & " [ " & p.products_model & " ] "

    What's wrong with this? I know we have some mysql guys in here.

    Quick run down.

    Trying to link 1 table to another based on product_id, want to update the title tag to the title tag with [ model ]

    Thanks guys!

    Michael
     
  2. intrktevo

    intrktevo New Member

    Joined:
    Oct 18, 2004
    Messages:
    5,781
    Likes Received:
    0
    Location:
    UCF
    Run the query in phpmyadmin, it'll tell you what the error is.
     
  3. LyFeWoRx

    LyFeWoRx 2 + 2 = 4 OT Supporter

    Joined:
    Jul 17, 2006
    Messages:
    120
    Likes Received:
    0
    Location:
    New York, New York
    Figured out the problem. Damn im a noob. I was using capitalization on the table names. I didn't know MySQL was case sensitive. Go figure. Most of the time I just copy the table names so it's never a problem, bad lazy habit.
     

Share This Page