Using MySQL Count function

Question

I want to count all user records and display them in tables, I am trying this code code, It displays the record for one user only, I want to display records from all users.

$u=$_POST['userid'];

$result1 = mysqli_query($con,"SELECT COUNT(user_id) as total FROM table-name where user_id=$u");

echo "<table border='1'>

</tr>

<tr>

<th>User ID</th>

<th>count</th>

</tr>";

while($row = mysqli_fetch_array($result1))
  {
  echo "<tr>";
 echo "<td>" . $u . "</td>";
  echo "<td>" . $row['total'] . "</td>";
   echo "</tr>";
  }
echo "</table>";
}

Callidior · Accepted Answer · 2014-04-27 06:33:06Z

1

Try the following SQL Query:

SELECT `user_id`, COUNT(`user_id`) as `total` FROM `table-name` GROUP BY `user_id`;

Refer to the documentation of the GROUP BY clause.

answered Apr 27, 2014 at 6:33

Callidior

2,9042 gold badges20 silver badges28 bronze badges

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

Comments

Ronak Shah · Accepted Answer · 2014-04-27 06:33:17Z

0

Use below:

$result1 = mysqli_query($con,"SELECT COUNT(user_id) as total FROM table-name");

where clause use for filter the data. refer http://www.w3schools.com/sql/sql_where.asp

answered Apr 27, 2014 at 6:33

Ronak Shah

1,5592 gold badges13 silver badges20 bronze badges

Collectives™ on Stack Overflow

Using MySQL Count function

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related