Hassle-free live chat software re-imagined for business growth. 2 users, always free.
SELECT subcategory.id as id,subcategory.sub_cat_name as subcategoryname,count(*) as total FROM subcategory,listing WHERE listing.city = '40' AND listing.category = '92' and (listing.subcategory=subcategory.id or listing.keywords like concat('%-', subcategory.id, '-%')) AND listing.status='Active' group by subcategoryname ORDER BY subcategoryname ASC please help me to make query fast... or any help
|Looping through dates, but October 2016 displays Sun 30th Oct twice - but no Mon 31st Oct?! All other 2016 months displays fine.||7||86|
|only allow numbers with preg match||4||24|
|how to use a function in heredoc||5||21|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!