[SOLVED] count or num_rows

[dreamwest]

Im using num_rows to cound how many rows there are in a table, but is count(*) faster

 

Heres what im using:

$result3 = mysql_query("SELECT id FROM table WHERE approve='1' ")or die(mysql_error());
$content_count = mysql_num_rows( $result3 );

 

Also i cant seem to get count to work, it only select about 200 rows, but there are over 30,000 rows

 

$content_count = mysql_query("SELECT COUNT(id) FROM table WHERE approve='1' ")or die(mysql_error());

echo $content_count;

 

[corbin]

Yes, COUNT() is most definitely faster.

 

 

Unless you actually plan on using every set of data you pull, use COUNT().

 

 

When ever you use mysql_num_rows, every data set has to be pulled from the SQL server.

[Ken2k7]

<?php
$sql = mysql_query('SELECT COUNT(id) cnt FROM table WHERE approve = 1');
$result = mysql_fetch_assoc($sql);
echo $result['cnt'];

[fenway]

Careful with specifying a field name inside COUNT() -- it's not the same as COUNT(*).

[Ken2k7]

fenway, good point. Since id columns are usually NOT NULL, COUNT(*) would be best.

[dreamwest]

<?php
$sql = mysql_query('SELECT COUNT(id) cnt FROM table WHERE approve = 1');
$result = mysql_fetch_assoc($sql);
echo $result['cnt'];

 

Thats did it, it loads much faster now.

 

Thanks