multiple-select-query

[Solved] How can I found Easy method for this in C# Windows base Application [closed]

by

Which database are you using? SQL Server 2008 or higher? If yes then the answer by @user3353613 will be useful. If not then you can pass comma/pipe(|) separated checkbox values to a single parameter to your stored procedure and then you can split the values inside the stored procedure to get what you need. Hope … Read more

[Solved] How to get search result by a keyword from different table in MySQL for php? [closed]

by

Maybe something like this? SELECT p.title, p.model_no, b.brand_name, c.category_title, s.specification_title FROM tbl_product AS p LEFT JOIN tbl_brand AS b ON b.id = p.brand_id LEFT JOIN tbl_category AS c ON c.id = p.category_id LEFT JOIN tbl_product_specification AS s ON s.product_id = p.id WHERE p.title LIKE ‘keyword’ OR p.model_no LIKE ‘keyword’ OR b.brand_name LIKE ‘keyword’ OR c.category_title … Read more