Display registered users

[treeleaf20]

I have the following code:

$sql = "SELECT COUNT(user_name) from users";
$result = mysql_result($sql);

First would that code work to get a count for registered users and what would be the best way to display this on the site.

Thanks for the help.

[exponder]

Try this. 🙂

<?
$query = "SELECT COUNT(*) AS numrows FROM users";
$numha = mysql_query($query) or die("Select Failed!");
$numha = mysql_fetch_array($numha);
if ($numha == 0) {
  echo "Error:" . mysql_error();
    exit();
}
?>

Place this where you want the query displayed:

There are <?= $numha[0]; ?> users in my database.