Join or Where?... Or What!

The_PHP_Newb

I have 2 tables, 1 has account data, the other has a list of accounts I don't want displayed (the list will be different for each id (in this case, its 98). Here is my code so far, can anyone help make this work?

$search = mysql_query("select * from table1,table2
where table1.id != 98
and table1.status = 1
and table1.credits = 1
and table2.uid = 98
and table1.id != table2.block");

Example of table 2:

UID Block
96 16
97 15
98 23
98 45
99 76

So I need to pull all accounts that meet the normal table1. criteria and weed out accounts that have a block value where UID = 98. In this case, the two accounts I need weeded out from table1 are 23 and 45.

Can someone help with this? Thanks!

TTT

where is the relation?

i think you want to use inner join...

SELECT * FROM table1 t1 INNER JOIN table2 t2 ON t1.id = t2.uid
WHERE t1.id != 98
and t1.status = 1
and t1.credits = 1
and t2.uid = 98
and t1.id != t2.block

The_PHP_Newb

Here is the relationship.

Table 1 has account info. Example:

ID username password ETC
1 michael racecars
2 jamesm stockcars
3 pokerp pocketaces

Lets say account ID #2 wants to "block" account ID #3 from being shown in his list of available members to contact. He can add them into his block list (table 2):

ID block_id
2 3

ID#2 has ID#3 blocked. Now I need to query a list of all accounts in table 1 (except any blocked IDs from table 2 - account ID #3 in this example).

Account ID #2 could have more than one blocks. Table 2 could read like this:

ID block_id
2 3
2 4
2 10
2 85

So in this case, we need to filter IDs 3, 4, 10 and 85 out of the list in table 1.

I've tried several queries (while, etc) and they all return the last result only (85). I can't get all the block_ids to be filtered from the list.

ANY help is much appreciated. This is the last piece we have to finish for the site and I'm sure it's something simple but I'm not familiar with advanced queries, etc.

TTT

$q = mysql_query("SELECT DISTINCT(t2.block_id) AS bid  

FROM table1 t1 INNER JOIN table2 t2 ON t1.id = t2.id 
WHERE t1.id != 98 AND t1.status = 1 AND t1.credits = 1 AND t2.uid = 98 AND t1.id != t2.block",$conn);

$bocked_ids = "";
while($row = mysql_fetch_row($q)) {
    $bocked_ids = $bocked_ids.$row[0].",";
}

// list is:
echo substr($bocked_ids,0,strlen($bocked_ids)-1);