duplicate data & jump menu

Discussion in 'PHP' started by rikyoni, May 7, 2007.

  1. #1
    1. I have table structure and record like this:

    tbDept(a)
    DeptID : 1,2,3,4,5

    tbPIC(b)
    PICID: 1,2,3,4,5,6,7,8,9...........
    DeptID : 1,1,1,2,3,4,5,1,1..........

    And I would like to display table for client side like this:
    ==========================
    Dept | Staf Name | Description |
    ==========================
    A | Alex | blabla |
    A | Betrand | zzzzzzzz |
    B | Thomas | ssstt |
    ==========================



    My question is, how if I don't want to display Dept for Staf Name is Betrand b'coz in the previous record (Alex) has same department with bertrand?

    2.
    Request Date : select box
    Request By: select box
    Status: select box
    Product: select box
    Department: jump menu


    I have form like above. If user select Department others input will be back to normal for example Request will be back
    to > All Request although user have selected it. How's the solution if input that user have selected remain the same
     
    rikyoni, May 7, 2007 IP