count query in mysql

 <?php
     $query = mysql_query("SELECT COUNT(*) as `order_id` FROM `order`;");
 $row = mysql_fetch_assoc($query);
 echo $row['order_id'];
  ?>