how to search for records in tow table

Discussion in 'PHP' started by abosirage, Jun 9, 2015.

  1. abosirage

    abosirage Member

    Joined:
    Jul 29, 2010
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    6
    Occupation:
    IT
    Location:
    Tripoli-Libya
    HI good friend
    I have to make search for data in tow table witch using the same column name & echo it in my php page please help me :cry::cry::cry:
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    What do you mean by tow table?
     
  3. abosirage

    abosirage Member

    Joined:
    Jul 29, 2010
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    6
    Occupation:
    IT
    Location:
    Tripoli-Libya
    very sorry I mean 2 not tow
     
  4. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
  5. abosirage

    abosirage Member

    Joined:
    Jul 29, 2010
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    6
    Occupation:
    IT
    Location:
    Tripoli-Libya
    Maybe I didn't clarify my request, I have two tables in data base with different number of columns, but it is similar to some of the columns label, and I want to search for data in the one of the similar column
     
  6. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    Either I am not able to understand or you have issues with your database design. If you have 2 tables, one of the table should have data as primary key or unique and other one should be foriegn key where you should be able to join.
     
  7. abosirage

    abosirage Member

    Joined:
    Jul 29, 2010
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    6
    Occupation:
    IT
    Location:
    Tripoli-Libya
    first of all I would like to Thank you very much for your attention to my problem, I would like to inform you that I repeat the search code for each table separately and echo the results in the same table so my problem solved
    Thank very much
     
  8. lovesamrat

    lovesamrat New Member

    Joined:
    Sep 19, 2015
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    Just implement a join on the fields.
     
  9. alia123

    alia123 New Member

    Joined:
    Jan 8, 2016
    Messages:
    65
    Likes Received:
    5
    Trophy Points:
    0
  10. emmawilson

    emmawilson New Member

    Joined:
    Mar 4, 2024
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Gender:
    Female
    Occupation:
    Developer
    Location:
    India
    Home Page:
    https://www.igmguru.com/salesforce/salesforce-developer-training/

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice