Explain Select

[musicbase]

Hi again

Any ideas how to find out the number of rows in a table using the EXPLAIN SELECT query?

Thanks
Richard

[drew010]

you can use

$res = mysql_query("DESC yourtable");
$rows = mysql_num_rows($res);

echo "This table has $rows fields.";

[justsomeone]

musicbase wrote:

Hi again

Any ideas how to find out the number of rows in a table using the EXPLAIN SELECT query?

Thanks
Richard

is there a reason why you want to use "EXPLAIN SELECT" instead of just "SELECT (1) from TABLENAME"?