[SOLVED] SELECT COUNT

[Cetanu]

<?php 
include "db.php";
$sql = mysql_query("SELECT COUNT(id) FROM users");
echo "MythScape has " .$sql. " members!";
?>

 

Why does this return:

 

" MythScape has Resource id #5 members!"

???

 

[simon551]

$query="SELECT id FROM table";

$rs=mysql_query($query,$connection);

$row=mysql_fetch_assoc($rs);

 

echo $row['id'];

 

in your case you are trying to echo the mysql operation. You can echo a query but not an operation like mysql_query();

[Alex]

Because you want to echo the count, you'd do this:

 

<?php 
include "db.php";
$sql = mysql_query("SELECT COUNT(id) FROM users");
$row = mysql_fetch_assoc($sql);
echo "MythScape has {$row['COUNT(id)']} members!";
?>

[Cetanu]

Oh okay. Thanks