Hey guys, I think I read this somewhere else on this forum but I wanted to confirm. Do you all believe that this method is a better way to retrieve the number of rows and is quicker than using the mysql_num_rows function?
###NUMBER OF USERS(FASTER)
$query = mysql_query("SELECT count(*) as user_count FROM users");
$results = mysql_fetch_assoc($query);
###NUMBER OF USERS(SLOWER)
$query = mysql_query("SELECT user_id FROM users");
$num_results = mysql_num_rows($query);
Also, I remember reading somewhere that if you want the count, you don't need to use the "*" symbol since it will read all columns, so instead just pick one column to get the count.