Re: Consultation SQL in field type Select [Solved]

Hello,

How I can create a consultation SQL for the values of a field type Select?

The values are in another field defined by the user and it must not have duplicities.

Since it has to be the structure?

Thank you and regards,

Toni

PD: Is it this?
id --> of the table SQL flexicontent_fields
Name --> name of the table SQL flexicontent_fields

Hello again,

Already I achieved that there works a simple consultation SQL of an own field but me duplicities appear.

I do not know anything of SQL.

The parameter WHERE works perfectly.

Since I use the parameter DISTINCT inside this consultation, to avoid duplicities?

Thank you, some suggestion please.

Regards !!

PD:

I hava SQL consultation ...

SELECT DISTINCT item_id AS value, value AS text FROM #__flexicontent_fields_item_relations WHERE field_id = 19

Hello again,

I will have to appeal a companion of work who is a programmer.

The language in which it has to be the instructions is ... PHP or SQL ???

Do some restrictions exist to bearing in mind?

Some thing that should be known?

Thank you and regards,

Toni

Hello,

Did someone return of vacations?

We will continue waiting for news.

Regards,

Toni

Hello,

Finally I could possess a companion of work that done me a cable with the code SQL.

The result has been brilliant.

Thank you and regards,

Toni