Count Table Record Value and Assign Count Value as Variable in PHP mySQL

Question

I have a database with area details like state name, district, city, area size, ...

Now I would like to count a districts value from state name and assign that value to some variable for showing html page.

Example: The tamil nadu state includes total of 30 districts.

Query for showing states list,

$qry = "SELECT DISTINCT state_Name FROM area_info ORDER BY state_Name";

How to do this.. anyone please help me..

Chiragkumar Thakar · Accepted Answer · 2015-05-22 06:22:14Z

2

You should try this, surely will solve your query.

$qry = "SELECT state_name, COUNT(district) As TotalData FROM area_info GROUP BY state_name";

edited May 22, 2015 at 6:22

answered May 22, 2015 at 6:09

Chiragkumar Thakar

3,7365 gold badges39 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Chiragkumar Thakar Over a year ago

@Dinesh Dinu, try this solution

Dinesh DiNu Over a year ago

thanks. im not showing this count value in my html table. i will use this as html <p> tag. For an example The tamil nadu state includes total of 30 districts. In that example tamil nadu is not a mandatory. total of 30 districts is a dynamic count value. my html code will be 'The tamil nadu state includes total of <?php echo $district_Cont; ?> districts.'

Chiragkumar Thakar Over a year ago

Modified my answer, check it now.

Chiragkumar Thakar Over a year ago

Count value will return you the number of districts.

Chiragkumar Thakar Over a year ago

@DineshDiNu Check it now

|

KTAnj · Accepted Answer · 2015-05-22 05:39:20Z

2

Try this

$qry = "SELECT DISTINCT state_Name, COUNT(*) AS district  FROM area_info Group BY state_Name" ;

answered May 22, 2015 at 5:39

KTAnj

1,3561 gold badge15 silver badges36 bronze badges

1 Comment

KTAnj Over a year ago

@Vickrant Example: The tamil nadu state includes total of 30 districts. State name is required. In addition Your answer is correct.

Manashvi Birla · Accepted Answer · 2015-05-22 05:39:55Z

2

To get the count of the record, you can use below query

$totaldist = "SELECT count(DISTINCT) state_Name FROM area_info GROUP BY state_Name";

and then to assign this variable you can write like :

echo "The tamil nadu state includes total of $totaldist districts.";

answered May 22, 2015 at 5:39

Manashvi Birla

2,8393 gold badges16 silver badges28 bronze badges

1 Comment

Dinesh DiNu Over a year ago

Guys.. Thanks for the replay.. but not works for me. I would to count total districts from my db and im willing to store that value to $district_Cont. when i add <?php echo $district_Cont; ?> the count value should be replaced.

Lennart - Slava Ukraini · Accepted Answer · 2015-06-23 10:32:40Z

2

Try this Query:

SELECT count(district) 
FROM area_info 
GROUP BY state_Name

edited Jun 23, 2015 at 10:32

Lennart - Slava Ukraini

7,2111 gold badge23 silver badges37 bronze badges

answered May 22, 2015 at 5:37

Vickrant

1,3312 gold badges9 silver badges15 bronze badges

Comments

jarlh · Accepted Answer · 2015-05-28 07:29:51Z

1

List with State name's and number of districts in it:

SELECT state_Name, COUNT(district)
FROM area_info
GROUP BY state_Name;

edited May 28, 2015 at 7:29

jarlh

44.9k8 gold badges52 silver badges68 bronze badges

answered May 22, 2015 at 6:23

Mnks

646 bronze badges

Collectives™ on Stack Overflow

Count Table Record Value and Assign Count Value as Variable in PHP mySQL

5 Answers 5

6 Comments

1 Comment

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

6 Comments

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related