I have a question, I want to get counts of different tables in one query to show on a page...
This the query i wrote, But it's not providing correct result..
SELECT COUNT(U.uID) AS total, COUNT(P.cID) AS Catmame FROM `dev_web_user` AS U, `dev_web_categories` AS P
Please note all count is independent, now join etc...
Please help me on this...
Thanks & Best Regards,