I am trying to figure out how to skip printing a row from a MySQL table if the variable is empty. For example, I have a table full of information. I have a while loop that gives the result. How can I skip a record if the variable is empty?
For example, is it possible to cancel the echo if "tweet1" is empty in the line?
mysql_connect ($DBsever, $DBusername, $DBpass) or die ('I cannot connect to the database becasue: '.mysql_error()); mysql_select_db ("$DBname"); $query = mysql_query("SELECT * FROM $DBtable ORDER BY time"); while ($row = mysql_fetch_array($query)) { echo "<br /><strong>".$row['time']." ".$row['headline']."</strong><br/>".$row['description']."<br />".$row['story1']." <a href=".$row['link1']." target='_blank'>".$row['link1']."</a> ".$row['tweet1']."<br />";}
source share