Page 1 of 1

getting values by joining with different id

Posted: Thu Aug 02, 2007 2:26 am
by shivam0101
Hello,

I have two tables,

Table 1: ID, gender, name

Table 2: FILE_ID mem_Id, file_name


ID and FILE_ID (auto inc, pk)

mem_id(fk)

whenever member uploads files, a new row is inserted into Table 2

I want to get all the filenames of members whose gender does not match with the Table 2 mem_id's gender. i.e if male logs in a female files should show.




Thanks

Posted: Thu Aug 02, 2007 3:04 am
by Christopher

Code: Select all

$sql = "SELECT files.* FROM files JOIN members ON files.mem_id=members.id WHERE members.gender<>'$gender'";

Posted: Thu Aug 02, 2007 9:51 am
by shivam0101

Code: Select all

$gender
?

That means i should get the gender in one query and then use another query to get files? Is it possible to get it in one query itself?