Tuesday, April 23, 2013

How to use comma seperate Ids values in JOIN Quereis



Example:

    Table: Customers

     Id  Ordersids
     10  2,3

     Table: Orders
     id price
     2   10
     3   11

     Query:

     select b.id, b.price from Customers a left join Orders b on find_in_set(b.id,a.orders) group by b.id


Bind Some Event to Element and trigger that function when click the element

Scenario: Suppose if we used same click event function in various web pages. if you want do some logic some page button for that need to re...