<div>
Another option is something like this ...<br />
<br />
&lt;?php-not-quite<br />
<br />
$r_Conn = mysql_pconnect(...);<br />
$s_SQL = 'Some query';<br />
$r_Result = mysql_query($s_SQL);<br />
$s_Rows = '';<br />
while(False !== ($a_Row = mysql_fetch_assoc($r_Resul<wbr />t)))<br />
&nbsp;{<br />
&nbsp;$s_Rows .= 'Add a TR to the list of rows';<br />
&nbsp;}<br />
mysql_free_results($r_Resu<wbr />lt);<br />
$s_Table = ('' !== $s_Rows) ? 'Table header' + $s_Rows + 'table footer' : '';<br />
echo $s_Table;<br />
<br />
?&gt;<br />
<br />
sort of thing.<br />
<br />
Basically, use a loop to build the output you want into a string.<br />
<br />
Outside of the loop, if the string contains anything, then there was data.
</div>


Another option is something like this ...

<?php-not-quite

$r_Conn = mysql_pconnect(...);
$s_SQL = 'Some query';
$r_Result = mysql_query($s_SQL);
$s_Rows = '';
while(False !== ($a_Row = mysql_fetch_assoc($r_Result)))
 {
 $s_Rows .= 'Add a TR to the list of rows';
 }
mysql_free_results($r_Result);
$s_Table = ('' !== $s_Rows) ? 'Table header' + $s_Rows + 'table footer' : '';
echo $s_Table;

?>

sort of thing.

Basically, use a loop to build the output you want into a string.

Outside of the loop, if the string contains anything, then there was data.

<div>
Hi, thanks so mcuh for your reply. Regards.
</div>


Hi, thanks so mcuh for your reply. Regards.

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I want to print a html table only if there is at least one row can be returned from a table. <br />
Foe example, something like: <br />
if ($rowNum &gt;0)<br />
//then &nbsp;print a html table<br />
&lt;&nbsp;table&gt; .....<br />
<br />
I guess I need to use mysql_num_rows () to determin the $rowNum. Is this a only choice? or there is a better choice in terms of performance?<br />
<br />
Thanks very much for your reply,<br />
lilyyan
</div>
</div>


Hello,

I want to print a html table only if there is at least one row can be returned from a table. 
Foe example, something like: 
if ($rowNum >0)
//then  print a html table
< table> .....

I guess I need to use mysql_num_rows () to determin the $rowNum. Is this a only choice? or there is a better choice in terms of performance?

Thanks very much for your reply,
lilyyan

how to determain at least one row is returned from a DB table?

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.