table linking

Discussion in 'PHP' started by white10, Jul 4, 2007.

  1. #1
    Hi Guys

    I want to display data from my agents table againts data from a client table , but each day new clients are added, and only those clients from that day must be displayed to the agents.

    Can anyone help me..
     
    white10, Jul 4, 2007 IP
  2. ajsa52

    ajsa52 Well-Known Member

    Messages:
    3,426
    Likes Received:
    125
    Best Answers:
    0
    Trophy Points:
    160
    #2
    Add a new field to your table. Their type can be numeric, date, alphabetic, ...
    Then set a different value depending on that criteria. For example '0' and '1'.
    And finally change your query to add that field. Example:
    select * from table where newfield=1;
     
    ajsa52, Jul 4, 2007 IP
  3. anjanesh

    anjanesh Well-Known Member

    Messages:
    344
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    165
    #3
    Can you do a DESCRIBE tablename ?
     
    anjanesh, Jul 4, 2007 IP
  4. white10

    white10 Peon

    Messages:
    38
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Thanks guys for the help, it worked very well
     
    white10, Jul 5, 2007 IP