title: [PHP]how to count a row in join table
body: <p>I'm trying to count the number of row in a table.</p>
  
  <p>i have the following code </p>
  
  <pre><code>$sqlPS = "SELECT o.id_order, o.tanggal_order, o.status_order,
                          d.jumlah_cetak, 
                          b.harga,
                          m.nama_lengkap
  
                          FROM order_data o, detailorder d, member m, cetak_foto b
  
                          WHERE
                          d.id_order=o.id_order
                          AND m.id_member=o.id_member
                          AND b.id_cetak_foto=d.id_cetak_foto
                          AND o.tanggal_order BETWEEN '$tgla' AND '$tglb'
                          ";
  </code></pre>
  
  <p>How to count the number of row in a table?
  thanks</p>
  
  <p>I tried : $sql_pd=mysql_query("SELECT COUNT(id_order) FROM order_data ");
  $get=mysql_num_rows($sql_pd); result =1. i have 3 record data</p>