如果满足特定条件，则无法过滤掉多行

Question

EDIT: ISSUE RESOLVED THANK YOU!

I'm having trouble figuring out a method to omit BOTH entries (time and message_time) from my echo'd Table in a row, if the value for $row['time']; is returned 0.

<?php
date_default_timezone_set('America/New_York');
// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup();
include($phpbb_root_path.'config.'.$phpEx);

mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die(mysql_error());
mysql_select_db("$dbname") or die(mysql_error());

// Get all the data from the "example" table
$result = mysql_query("SELECT * FROM phpbb_mchat WHERE user_id = '$userid' ORDER BY     message_time DESC") 
or die(mysql_error());  

echo "<table class='sortable'>";
echo "<tr> <th>Saved On</th> <th>Time (MM:SS)</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
if ($row['time'] != "0") {
echo "<tr><td>"; 
echo $row['message_time'] =  date( "F j, Y, g:ia", $row['message_time']);
echo "</td><td>"; 
echo $row['time'];
echo "</td></tr>";  
 }
}

echo "</table>";
?>

Answer 1

Assuming you are trying to omit rows in the table where "time" is 0

while($row = mysql_fetch_array( $result )) {
  // Print out the contents of each row into a table
  if ($row['time'] != "0") {
    echo "<tr><td>"; 
    echo $row['message_time'] =  date( "F j, Y, g:ia", $row['message_time']);
    echo "</td><td>"; 
    echo $row['time'];
    echo "</td></tr>";  
  }
}

The entire row will be omited if $row['time'] is 0