2. PHPRunner General questions
  3. Query Help
This topic is locked

Query Help

 		8/29/2009 9:38:53 AM
PHPRunner General questions
author

Here is the query I'm using

SELECT

jos_users.id,

jos_users.name,

jos_users.username,

jos_users.email,

jos_users.password,

jos_users.usertype,

jos_users.block,

jos_users.sendEmail,

jos_users.gid,

jos_users.registerDate,

jos_users.lastvisitDate,

jos_users.activation,

jos_users.params,

jos_community_fields_values.user_id,

jos_community_fields_values.field_id,

jos_community_fields_values.value,

jos_community_fields_values.id AS id1,

jos_users.Job_Title

FROM jos_users

, jos_community_fields_values

WHERE jos_users.id = jos_community_fields_values.user_id AND jos_community_fields_values.field_id = 18


What I want to do is take the value of
The query is working but when I build the application and deploy the [color="#FF0000"]jos_community_fields_values.`value is not Searchable because it not part of the jos_users table.
Thanks in advance for any help!!!
jm
501357 8/29/2009

Solved this myself..I had the field "Value" non searchable.
501358 8/29/2009

Same querry...but I want to add another id in the Where statement. I need to add jos_community_fields_values.field_id = 10 also
and would like this to go in jos_community_fields_values.valueAs State field.

SELECT

jos_users.id,

jos_users.name,

jos_users.username,

jos_users.email,

jos_users.password,

jos_users.usertype,

jos_users.block,

jos_users.sendEmail,

jos_users.gid,

jos_users.registerDate,

jos_users.lastvisitDate,

jos_users.activation,

jos_users.params,

jos_community_fields_values.user_id,

jos_community_fields_values.field_id,

jos_community_fields_values.value,

jos_community_fields_values.valueAs State,

jos_community_fields_values.id AS id1,

jos_users.Job_Title

FROM jos_users

, jos_community_fields_values

WHERE jos_users.id = jos_community_fields_values.user_id AND jos_community_fields_values.field_id = 18