[SOLVED] Simplest Way to Display Select Count(*)

[limitphp]

If I have a simple query:

$query = "select count(*) from table";

$mysql_query($query) or die (mysql_error());

 

What is the simplest way to display the actual number of rows returned?

 

since I'm not actually grabbing a row, I'm not sure how to display the count.

[GraphiX]

$sql = "SELECT * FROM `table`";

$query = mysql_query($sql) or die(mysql_error());

echo mysql_num_rows($query)

 

I think that would work.

 

The way you're doing it would also work.

[redarrow]

Can be done this way as well mate.

<?php 
//database connection.


/// select with count.
$query = "select count(*) as num from table";
//query select.
$mysql_query($query) or die (mysql_error());
//loop query.
while($row=mysql_fetch_array($mysql_query)){
//echo result.
echo $row['num'];
}
?>

and this way.

 

<?php 
//database connection.


/// select with count.
$query = "select count(*) as num from table";
//query select.
$mysql_query($query) or die (mysql_error());

//echo result.
echo $mysql_query['num'];

?>

 

[limitphp]

$sql = "SELECT * FROM `table`";

$query = mysql_query($sql) or die(mysql_error());

echo mysql_num_rows($query)

 

I think that would work.

 

The way you're doing it would also work.

 

thanks guys!

 

 

 

 

[GraphiX]

would display as a number I think, never used that method though.

[trq]

$query = "select count(*) from table";
$result = mysql_query($query);
echo mysql_result($result,0);

 

[limitphp]

$query = "select count(*) from table";
$result = mysql_query($query);
echo mysql_result($result,0);

 

 

whoa.....awesome...thank you.

[premiso]

If you want just the count, this is the better/preferred method:

 

<?php
$sql = "SELECT count(id) as cnt FROM `table`";
$query = mysql_query($sql) or die(mysql_error());
$cnt = mysql_result($query, 0);
echo $cnt;
?>

 

Do not use count(*) as it is slower and less efficient. Defining a column is much faster and you should generally use the index/primary key column.

 

EDIT:

Sort of beaten to it by Thorpe, but yea, since I do not use count(*) I figured this was ok to post

[limitphp]

If you want just the count, this is the better/preferred method:

 

<?php
$sql = "SELECT count(id) as cnt FROM `table`";
$query = mysql_query($sql) or die(mysql_error());
$cnt = mysql_result($query, 0);
echo $cnt;
?>

 

Do not use count(*) as it is slower and less efficient. Defining a column is much faster and you should generally use the index/primary key column.

 

EDIT:

Sort of beaten to it by Thorpe, but yea, since I do not use count(*) I figured this was ok to post

 

Oh, ok.....thank you.

yeah, that was exactly what I wanted...just the count....

thanks guys.