[SOLVED] how can i count the number of rows in a DB and echo the amount?

[frijole]

how can i count the number of rows in a DB and echo the amount? I would like to list the number of people signed up for an email list.

[trq]

<?php

  $sql = "SELECT COUNT(id) AS cnt FROM emaillist";
  if ($result = mysql_query($sql)) {
    if (mysql_num_rows($result)) {
      $row = mysql_fetch_assoc($result);
      echo "There are {$row['cnt']} users on the email list";
    }
  }

?>

[laffin]

one of 2 ways

 

// U can do this
$res=mysql_query('SELECT COUNT(*) FROM users');
echo mysql_result($res,0,0);
echo '<BR>';
// or U can do this
$$res=mysql_query('SELECT * FROM users');
echo mysql_num_rows($res);