Select one table count(*) from multiple tables MySQL

Select from one table count(*) from two tables MySQL

SELECT *, 
(SELECT COUNT(postid) FROM posts where user = 4) AS counter,
(SELECT COUNT(revid) FROM reviews where userid = 4) AS counters
FROM users where usid = 4 LIMIT 1

rated 3 times [ 3] [ 0] / comments: 0 / hits: 1542 / 3 years ago, wed, aug 2, 2017, 17:43:46

Comments

There are no comments for this Snippet yet

Snippets

Bind variables in ADODB

Using bind variables with ADODB

4 years ago, tue, sep 6, 2016

ADOdb Performance Monitor

This module provides HTML and CLI interfaces for viewing key performance indicators of your database.

4 years ago, tue, sep 6, 2016

Check if php mail function is enabled

How to check if mail function is enabled on your server

4 years ago, tue, sep 6, 2016

Compare dates in smarty

Compare dates in smarty template file

4 years ago, fri, sep 16, 2016

Chrome input style

Change default chrome input style CSS

4 years ago, fri, sep 16, 2016

Get domain name without Tld

Get domain name without Tld with PHP

4 years ago, fri, sep 16, 2016

Validating international phone numbers

Validating international phone numbers with jquery

4 years ago, sun, sep 25, 2016

Smarty Remove BBCode

Smarty Remove BBCode From String

4 years ago, thu, nov 10, 2016

How to check if uploaded file is image in php

How to detect if uploaded file is image or not with php

4 years ago, mon, nov 21, 2016

How to check CKEditor textarea not empty

How to check CKEditor 4 textarea not empty

4 years ago, sun, dec 25, 2016

Posted

Ronald

Member since Sep 6, 2016

Total Points: 127

Total Code Snippets: 22

Total Comments: 1

Location: n/a

Following

User not following anyone yet.

Select one table count(*) from multiple tables MySQL

Comments

Username

Your Comment

Ronald