Filtering out Certain Records

Hi Jason,

just need to remove from this section of code only. The feild is in the destination table.

Have attached the page. Code snippet starts on line 96.

The page looks like this:
sailconnections.dreamhosters.com/yacht-type.php/sailing-1/

Im hoping to suppress the Mediterranean link and a few others from the list of yachts.

Many thanks
Jan

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!