Getting field names

[liamoco]

Hello, I want to get all field names from a table called `profileInfo_choose` where field names = 1 AND user_id=$user_id

 

How is this done?  Or what is the best way if a single query cannot do the job?

 

Thanks

[mikosiko]

Hello, I want to get all field names from a table called `profileInfo_choose` where field names = 1 AND user_id=$user_id

 

How is this done?  Or what is the best way if a single query cannot do the job?

 

Thanks

 

you want the "FIELD NAMES" ?.... based on a condition where you are already using some of the field names?.... no make any sense.... maybe you are trying to get all the rows (values) where the condition is TRUE ?...

 

post your table description 

[liamoco]

user_id | fullName | dob | gender | relationship | looking | hometown |

----------------------------------------------------------------------------------------

    5      |      1      |    1  |      1    |        0          |      0      |        1        |     

 

OK getting down to what I want to accomplish is to get all the field names that = 1 where user_id='5'

[mikosiko]

your objective no make sense    ... you should think again about your goal  ... and think based on how SQL works... apparently what you want is select all the records where user_id = 5 and then you can choose to show or not the fields if the value = 1 (the name of the field is irrelevant because you can alter it every time you want (aliasing) ).

[mikosiko]

complementing my previous answer... you should look for the usage of mysql_field_name() and use it in the previous explained context.

http://php.net/manual/en/function.mysql-field-name.php

 

hope this help.

[fenway]

It looks like you're using these as flags -- if so, they should be in another table, and that way, you can simply search for "where any attribute is set", and you don't have to get back field names.