how to convert mysql count output into php variable [duplicate]

Question

I'm trying to count the number of entries in the 'classcode' column of my db which have 'class1' as the value and then convert this number into a PHP variable. Any ideas where I'm going wrong? Any help much appreciated

$result = mysql_query("SELECT COUNT(classcode) FROM playerinfo WHERE classcode='class1'");

$count = mysql_result($result, 0);

echo $count;

Note: The mysql_* functions are deprecated, they have been removed from PHP 7, your code will stop working when you upgrade to that version. You should not write new code using them, use mysqli_* or PDO instead. — Gerald Schneider
– Gerald Schneider, Commented Sep 14, 2016 at 6:44

Gerald Schneider · Accepted Answer · 2016-09-14 06:43:52Z

1

Try this:

$result = mysql_query("SELECT COUNT(classcode) as count FROM playerinfo WHERE classcode='class1'");

$result_array = mysql_fetch_assoc($result); 
$count = $result_array['count']

echo $count;

edited Sep 14, 2016 at 6:43

Gerald Schneider

17.8k10 gold badges64 silver badges79 bronze badges

answered Sep 14, 2016 at 6:39

user3040610

7604 silver badges15 bronze badges

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

2 Comments

Gerald Schneider Over a year ago

Pease do not advocate the deprecated mysql_* functions.

Beginner Over a year ago

mysql is deprecated in higher php version

Collectives™ on Stack Overflow

how to convert mysql count output into php variable [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related