Filtering out Certain Records

Hi Jan,

In which table would the field suppress appear? Do you need to remove those records from the entire page, or just from this one section of code?

If you could attach your entire .php page, I can take a closer look into the issue for you.

Hope this helps.

Hi Jan,

Since we're not actually selecting records from the destinations table, try this code (I've highlighted the changes in red):

<?php foreach ($valuesToLabels as $value => $label): ?>
<?php
$where ="num =".intval($value)." AND suppress=1";
if(mysql_select_count_from('destinations',$where)){
continue;
}
?>
<?php echo ($count2==0)? "" : ", " ?><a href="/destination.php/<?php echo str_replace(" ","-",strtolower($label."-".$value)); ?>/"><?php echo htmlspecialchars($label); ?></a>
<?php $count2++;?>
<?php endforeach ?>

This code assumes that the table is called "destinations". If not, you'll need to change the code to reflect that. What this is doing is for each destination number in the array, it checks if that record has suppress set to 1. If it does, it skips to the next record in the list.

Hope this helps.

Perfect, thanks Jason!