i have two dropdown list with same city name based on select citys record change on table on button click

2895 views jquery
8

list one              list Two


       from                  TO

       pune                  Mumbai
       nanded                pune
       mumbai                nanded

Database

    id    date         from       two
    1     1/11/2018    pune       nanded
    2     3/11/2018    mumbai     pune

i want two show in table selected citys wise data

answered question

1 Answer

3

seems you need the union between from and to selected from the samme table

    select `from`
    from  my_table  
    union 
    select `to`
    from  my_table  

posted this

Have an answer?

JD

Please login first before posting an answer.