Loading

Count number of users from a table

Vineet Kumar Saini

Hi Friend..

I have a login table in database. There are three fields i.e id, user_id, city. I want to know ,how to get number of users which have same city (like as noida) ?

Please tell me anyone ? Please help me ?

Thanks

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kunal Vaishya14y ago
Accepted answer
Dear try this

Select Count(*) As TotalUser From LoginTable Where City Like '%Noida%'
0
Kunal Vaishya14y ago
See anny Keyword Missiong or Not Query BCoze if it execute proper in BackEnd its Must be Execute in Front Side
if Still any

Confusion then let me know i am here

0
Vineet Kumar Saini14y ago
Hi kunal Your query proper execute in back end(MYSQL) but not proper execute in front end (PHP).
0