Populating dropdown

[Phpfr3ak]

Could anyone point me in the correct direction of how to go about excluding results from a drown down menu, Basically i'm calling everyone who's a contact to the user in the code below, id like to remove contacts who already have a bank account with the user, So basically its something along the lines of if the player_id is already in the table bank_accounts as PlayersID, then its excluded, Hope this makes sense and any help would be great, Thanks

 

 <select name="contact1" class="maintablepstats" id="contact1">
<option value=""></option>
<?php
$sql = "SELECT player_id, contact_id, name, is_active FROM contacts as c JOIN players as p ON c.contact_id = p.id WHERE c.player_id = $playerID AND is_active = 1 ORDER BY name ASC";
$que = mysql_query($sql) or die(mysql_error());
while($list = mysql_fetch_array($que)) {
?>
<option value="<?php echo $list['contact_id'] ?>"><?php echo $list['name'] ?></option>
<?php } ?>
</select>

[Proletarian]

So out of a list of contacts, you want to select only contacts that meet a specific criteria?

[Phpfr3ak]

Yea, if there $playerID is in bank_accounts as PlayersID, i dont want them to display in the dropdown.

[Proletarian]

SELECT * FROM table WHERE (table.contact = criteria)?

 

I dunno, this looks like an SQL question, not a PHP question.