I need to search a table for all data where column_1 = column_2. I then need to search a 2nd table for all data where column_x != $result_from_1st_search.
A) Is it possible to do all this in one query?
😎 If not, how can I do this without using WHILE w/ a fetch_array(if at all).
Example of what I need done (not coded correctly at all):
$ck1 = mysql_query("select id from tbl_1 where id = '178'");
$ck2 = mysql_query("select id from tbl_2 where id != '$results_from_above' and id != '$178'");
I need the results from ck1 put into an array without using WHILE. Using a normal array, I can't figure out how to get multiple values into 1 variable because the results from tbl_1 might be anywhere from none to 100.
This is a filter that members can select to filter the view of other members. ck1 is table that has 2 columns, the member id and a flitered (blocked) id. I need to check that table for all instances where the member id is found, get the block id and array it into a variable then display data from ck2 where id != the blocked id's.
Confused yet? I'm not very good at expressing what I need done... hopefully someone knows what I'm trying to get at.
