A table related to itself / advanced mysql select question

Hi,

This should work:

<?php $numValue = (@$ESCAPED_FILTER_VALUE )? $ESCAPED_FILTER_VALUE : '0'; ?>
SELECT num, CONCAT(client,' / ',title)
  FROM `<?php echo $TABLE_PREFIX ?>portfolio_projects`
  WHERE hidden = 0 AND num != <?php echo $numValue; ?>

Then below the text area where you entered this there should be a drop down list called Advanced Filter, you need to select num field from the drop down list. 

The escaped value will get the current value from the num field. If the value isn't set because you're creating a new record then the num value will be set to zero in the where statement and all records will be shown. 

Let me know if you have any questions.

Thanks!

Greg

Glad you've got it working. 

The first line of code is a way to create a simplified if statement, if you wrote it using if/else it would look like this:

if(@$ESCAPED_FILTER_VALUE){
  $numValue = $ESCAPED_FILTER_VALUE
}else{
  $numValue = '0'
}

But it can be shorted to:

<?php $numValue = (@$ESCAPED_FILTER_VALUE)? $ESCAPED_FILTER_VALUE : '0'; ?>

So $numValue will be equal to $ESCAPED_FILTER_VALUE if it exists, else it will be equal to zero. But you could put any normal if statement in the brackets, eg:

<?php $weatherString = ($temperature > 30)? 'Hot' : 'Cold'; ?>

Thanks!

Greg