How do I skip an item in while loop if variable empty?

Question

I'm trying to figure out how to skip printing a row from a MySQL table if the variable is empty. For instance, I have a table full of information. I have a while loop that echos the result. How can I skip an entry if a variable is empty?

For instance, can I cancel the echo if 'tweet1' is empty in the row?

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 />";}

use a condition and a continue to move on to the next iteration. — thetaiko
– thetaiko, Commented Nov 26, 2011 at 2:49

robert · Accepted Answer · 2011-11-26 02:49:28Z

15

You can use continue control structure for skip an iteration. Please read the docs

Example:

if(!$row['tweet']) {
  continue;
}

answered Nov 26, 2011 at 2:49

robert

8,7479 gold badges47 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Adam Wenger · Accepted Answer · 2011-11-26 02:51:59Z

6

You could also not return rows without information in tweet1, this would make the php check for data in tweet1 unnecessary.

$query = mysql_query("SELECT * FROM $DBtable WHERE tweet1 IS NOT NULL ORDER BY time");

answered Nov 26, 2011 at 2:51

Adam Wenger

17.7k8 gold badges55 silver badges65 bronze badges

Comments

Kevin Ji · Accepted Answer · 2011-11-26 04:29:05Z

6

if (empty($row['tweet'])) {
    continue;
}

edited Nov 26, 2011 at 4:29

Kevin Ji

10.5k4 gold badges43 silver badges65 bronze badges

answered Nov 26, 2011 at 2:51

Sudhir Bastakoti

100k15 gold badges163 silver badges169 bronze badges

Comments

sooper · Accepted Answer · 2011-11-26 02:49:11Z

1

Try:

while ($row = mysql_fetch_array($query)) {
if ($row['tweet1']) 
    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 />";
}

answered Nov 26, 2011 at 2:49

sooper

6,0496 gold badges43 silver badges65 bronze badges

Comments

iCantSeeSharp · Accepted Answer · 2011-11-26 02:52:36Z

0

while ($row = mysql_fetch_array($query)) {
  if (!empty($row['tweet1'])    {
    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 />";
  }
}

answered Nov 26, 2011 at 2:52

iCantSeeSharp

3,8904 gold badges48 silver badges69 bronze badges

Collectives™ on Stack Overflow

How do I skip an item in while loop if variable empty?

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related