Check Mysql field?

[Drewdle]

I have this script running:

 

<?php
$query = mysql_query("SELECT * FROM jobs WHERE event = 'Yes' ORDER BY title");
while ($row = mysql_fetch_array($query)) {
?>

 

How do I check if a field is empty and NOT display it...?

 

For instance it has a 'applied' field, if that is empty I dont want it to display, however I still  need the event = 'Yes' part.

 

 

[codefossa]

<?php
$result = mysql_query("SELECT * FROM `jobs` WHERE `event` = 'Yes' AND `applied` != '' ORDER BY `title` ASC;");
while ($row = mysql_fetch_assoc($result))
{
  // Use
}
mysql_free_result($result);
?>

[codefossa]

Meant to modify not quote.

[Drewdle]

Thanks, your a saviour!

[codefossa]

Thanks, your a saviour!

No problem.  Glad to help.