which is more efficient

[EchoFool]

Hey,

 

Just wondering which is more efficient in these 2 scripts as i love being as efficient as possible:

 

SELECT Count(ID) AS TotalID FROM table WHERE ID = 2
//display
echo $row['TotalID'];

 

OR

 

$QUERY = SELECT ID FROM table WHERE ID = 2
//display
echo mysql_num_rows($QUERY);

[premiso]

Count would be more efficient, as doing a query will pull all ID's from the database, where count does what it says and just counts the data.

[EchoFool]

Okay thanks