www.webdeveloper.com
Results 1 to 2 of 2

Thread: Nice Easy Join Problem

  1. #1
    Join Date
    Mar 2013
    Location
    Australia
    Posts
    3

    Nice Easy Join Problem

    Hi there,

    Im learning mysql and php. I have come across a little problem. (I have done a lot of reading but cant seem to get my head around the solution... Maybe over reading, and I only jumped on here as I really cant figure it out)

    But... Here it is...

    I have two tables:

    T1
    ID, t1_name, t1_value

    T2
    ID, t2_name, t2_otherstuff, t2_morestuff, t2_heapsstuff, etc,

    What Im trying to do is do a SELECT where it will return the result of "t1_value" based on the "t2_name = t1_name". So then I can ECHO out the "t1_value".

    The "id"s dont and wont match, just the "names" are the same (from a dropdown value populated from T1.)


    I get how to do a SELECT and result from one table but cant figure out how to do one with two tables.

    Im sure this is a simple answer for you pros out there, but this Newbie would appreciate your help
    (and please feel free to explain the answer to, as I wont learn if I dont know why the answer is as it is.).

    Thanks Heaps...

  2. #2
    Join Date
    Mar 2013
    Posts
    16
    You should take a look at a couple of tutorials, maybe video tutorials, just search youtube for ' join tables in mysql '. Hope this helps

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

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



Recent Articles