Php Mysql multisearch functionality -


the issues finding particular businesses based on multi categories. following mysql tables:

business_tbl:

id | business_name | cat_id | cat2_id | cat3_id | sub_cat_id | sub_cat2_id | sub_cat3_id 1       bz1            1      2          3         1001          2001         3001 2       bz2            1      2          3         1002          2002         3002 3       bz3            1      2          3         1003          2003         3003

business_categories_tbl:

id | cat_name  1     food  2     restaurants  3     wine

business_sub_categories_tbl:

b_sub_cat_id | b_sub_cat_name | b_maincat_id  1001             donuts          1  1002              xx             1  2001             steakhouse      2  2001              yy             2  3001            white            3  3002             zz              3

how can find particular business name based on multi category search? example how mysql query need can search through category ie cat_id, cat2_id , cat3_id, sub_cat_id ,sub_cat2_id , sub_cat3_id , return business_name if match found. current query perform 1 cat_id , 1 sub_cat_id search since joining multi categories not returning anything.thanks

what understand post try build below query. try it:

select business_name   business_tbl '1002' in (cat_id, cat2_id , cat3_id, sub_cat_id ,sub_cat2_id, sub_cat3_id)

Comments

Post a Comment

Popular posts from this blog

asp.net mvc 3 - Using mvc3, I need to add a username/password to the sql connection string at runtime -

i see how build string using stringbuilders (sql/entity framework); do cause connection string used in dbcontext? example context: public class pophistorydbcontext : dbcontext { public dbset<pophistory> histories {get;set} } public class pophistoryrepository: ihistoryrepository { private pophistorydbcontext context = new pophistorydbcontext(); public iqueryable<pophistory> histories{ {return context.histories;} } } example usage in controller: public class historycontroller : controller { private ihistoryrepository repository = new pophistoryrepository(); var histories = h in repository.histories (h.modifytimestamp > today) select h; if (!string.isnullorempty(searchstring)) { histories = histories.where(h => h.dn.toupper().contains(searchstring.toupper())); } thank you
Read more

kineticjs - draw multiple lines and delete individual line -

i can draw multiple lines on canvas; added layer using drawscene dlayera1.add(line); line.getpoints()[0].x = mousepos.x; line.getpoints()[0].y = mousepos.y; line.getpoints()[1].x = mousepos.x; line.getpoints()[1].y = mousepos.y; moving = true; dlayera1.drawscene(); http://jsfiddle.net/user373721/xzead/1/ . is there way delete individual line? currently, you'll have modify points array this: line.getpoints()[0].splice(index, 1); since arrays modified reference, modifying returned array modifies "source of truth" points array attr
Read more

thumbnails - jQuery image rotate on hover -

any chance change image src on hover , count 10 , again first? this need, default thumb, flv-3.jpg ! <img src="/thumbs/e/b/d/6/d/ebd6d2d6d99e/ebd6d2d6d99e.flv-3.jpg" /> on mouse hover need change number flv-1.jpg flv-2.jpg flv-3.jpg flv-4.jpg etc.. up 10, , again , start number 1, when move mouse thumbs need default thumb flv-3.jpg this im use not solutions, var _thumbs = new array(); function changethumb(index, i, num_thumbs, path) { if (_thumbs[index]) { document.getelementbyid(index).src = path + + ".jpg"; preload = new image(); preload_image_id = (i + 1 > num_thumbs) ? 1 : + 1; preload.src = path + preload_image_id + ".jpg"; = % num_thumbs; i++; settimeout("changethumb('" + index + "'," + + ", " + num_thumbs + ", '" + path + "')", 800) } } function startthumbchange(index, nu
Read more