mysql data into php variable

[bruckerrlb]

I'm trying to test to see if the output from a mysql table is a certain number or not and if it is, then display the results but I seem to be having the hardest time getting this to work even though it seems really simple.

 

If I have

$query_it = mysql_query("SELECT  * FROM swusers
LEFT JOIN `swcustomfieldvalues` ON swusers.userid = swcustomfieldvalues.typeid
LEFT JOIN swcustomfields as fields ON swcustomfieldvalues.customfieldid = fields.customfieldid
LEFT JOIN swcustomfieldgroups AS groups ON fields.customfieldgroupid = groups.customfieldgroupid
WHERE fields.customfieldgroupid = '19' LIMIT 50") or die(mysql_error());

The reason that the customfieldgroupid is = 19 is because I want to bring back all custom fields on a user in the group which has an id of 19

 

 

How can I bring back all users who have a record in customfields where the customfieldid = 51

 

I've been muttering the above statement to myself for more hours than I care to admit, so if it doesn't make sense let me know and I can try to explain it a little better

[Mchl]

Like this?

 

SELECT  * FROM swusers
LEFT JOIN (SELECT * FROM `swcustomfieldvalues` WHERE customfieldid = 51) AS `swcustomfieldvalues` ON swusers.userid = swcustomfieldvalues.typeid
LEFT JOIN (SELECT * FROM swcustomfields WHERE customfieldgroupid = '19') as fields ON swcustomfieldvalues.customfieldid = fields.customfieldid
LEFT JOIN swcustomfieldgroups AS groups ON fields.customfieldgroupid = groups.customfieldgroupid
LIMIT 50