$result = mysql_query($sql); while($row = mysql_fetch_assoc($result)) { if(!empty($row['company'])) { echo '<tr><td>Company name</td></tr>'; } if(!empty($row['contact'])) { echo '<tr><td>Contact name</td></tr>'; } if(!empty($row['add1'])) { echo '<tr><td>Address 1</td></tr>'; } if(!empty($row['add2'])) { echo '<tr><td>Address 2</td></tr>'; } if(!empty($row['city'])) { echo '<tr><td>City, State Zip</td></tr>'; } }