mySQL query help

Discussion in 'PHP' started by KingCobra, Nov 20, 2009.

0
  1. #1
    [​IMG]

    I have 3 table and want to run a query to get the result like result table.
    Using php I will send 2 value like red text of above image.
    What will be the query to get result like the result section of above image?

    Please help me.
     
    KingCobra, Nov 20, 2009 IP
  2. cignusweb

    cignusweb Peon

    Messages:
    147
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #2
    use this and modify according to your requirement.

    "Select * form users_share as a, share_type as b , daily_trade as c where a.user_id='1' and a.folio_id='1' and a.share_id=b.share_id and b.share_code=c.code group by a.share_id"
     
    cignusweb, Nov 20, 2009 IP
  3. KingCobra

    KingCobra Well-Known Member

    Messages:
    289
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    103
    #3
    cignusweb,

    THANK YOU VERY MUCH.
    Your code works perfectly what I needed.
    * just replace 'form' to 'from'

    You are rock man.
     
    KingCobra, Nov 26, 2009 IP