More efficient way to COUNT() MYSQL rows via PHP?

Question

Here is how I am currently counting mysql rows in PHP:

//GET total # of results and build $start and $end for main SQL statement
$sql= 'SELECT COUNT(*) FROM savedsearches WHERE user_id=\''.mysql_real_escape_string($user_id).'\'';
$initial_query = mysql_query($sql) or die("SQL error");
$num_sql = mysql_fetch_array($initial_query);
$numrows = $num_sql[0];
mysql_free_result($initial_query);

Is there a more efficient way to do this?

Answer 1

You mean, do it in fewer lines of code? You could put that functionality into a user-defined function and then call the function instead of using that code, but other than that, it's not going to get an awful lot terser.

Answer 2

Check this: http://tr.php.net/manual/en/function.mysql-num-rows.php

Answer 3

No. If you want a count , you run the query you're already running.

If you need more efficiency, make sure there is an index on the user_id column