Help with query

[tobeyt23]

I have a table for that we will enable products and a fieldname in another table I reference that field name. How can i query the the product table to get the fieldname if enabled and then pull for the other table where fieldname matches.

 

table 1:

 

id: 1

name: test

enabled 1

fieldname is_test_active

 

table 2:

 

id: 1

is_test_active: 1

 

 

 

[cyberRobot]

Have you tried using JOIN? More information about the different join types can be found here:

http://dev.mysql.com/doc/refman/5.0/en/join.html