PDO query help?

[Mr Chris]

Hello,

 

Wondering if anyone can help me with a PDO query for outputting a html table.  Take this query:

 

function outputSchedule ($dbc) {
  $QUERY = $dbc->query("SELECT * from tbl");  
  $QUERY->setFetchMode(PDO::FETCH_ASSOC);  
$output ='
<table>
  <thead>
      <tr> 
        <th>Name</th>
        <th>Weight</th>
      </tr>
   </thead>
  <tbody>'; 

while($ROW = $QUERY->fetch()) { 
$output .=' 
<tr> 
  <td style="width:160px;'.$bg.'">'.$ROW['name'].'</span></td>
  <td style="width:180px;'.$bg.'">'.$ROW['weight'].'</td>         
  </tr> ';
    }

$output .='
    </tbody>
    </table>';
return $output;
}

 

You will see I run through a loop to catch all my records in my database, however my problem is with my table headings and the closing of my table.  Say there are no records in the database then the start of the table will automatically print (where the <th>'s are) as well as the end of the table.  So I want to basically want to use mysql_num_rows to achieve this.  Now if it was in a normal query i'd be fine ($NUM = mysql_num_rows then if $NUM > 0, outputting a message if there are no rows in the database).  However, i'm not at all sure how to do it using PDO as what I used threw up errors, can anyone help?

[trq]

The PDO statement object has a rowCount() method.

 

http://php.net/manual/en/pdostatement.rowcount.php

[Mr Chris]

Thanks Thorpe.  Sorted now