getting image in a select field when the image name is in th

hello
I have read the french FAQ 'Création d'un champ liste déroulante qui affiche des images' which allows to get images in the select field.

I need to do that but with images which are in an article. I get easily the title and the id of the article from jos_content. But how can I get the image which is in a user-field ?

thank you for help

best regards

Michel

hello, you want to extract an image URL of an image added in item's description or in a textarea field ? other?

I have an - Image / Image Gallery - field.
I want to get the url of this image to show it in another select field.

The image contains portrait of people. In the public part I want to show the image of the chosen person in the admin and when I put the mouse on the image I get a tooltip of his name.

To get the name no problem. It's the title of my article . I have done a SQL query in the select field to get the id and title of the article. My problem is to get the image which seems to be in another table.

other field of SAME item ?

I'm managing a library.

I have created a category which contains exclusively the biography of people. the title of each article is the name of the person.
The description field is the biography.
I have added an image/gallery field to have photos of the person.


I have created another category which contains books description
In this category I have a select field which contains the name of the authors of book. This field is managed by a SQL query which gives the id and the title of the biography of the article.

I want to get also the first image which is in the biography article to show an image in the front view of the book description.

My question is how get the image which seems to be in another table than the jos_content one.

best regards

Michel

hello

I advance in my library project. But I'm a little bit blocked now and I'm asking if what I want to do can be done easaly with Flexicontent :


I have 2 categories of articles :
- books
- authors (an author may have more than one book).

in the book I have the following info :
- name of the book (title of article)
- summary of the book (description)
- image of the cover (additionnal image/gallery field)
- name of the author (additionnal select field)
- name of the publisher (text field)
- date of publication (date field)
- ...

in the author category :
- title of the article : name of the author
- description : summary of the book
- additionnal fields :
- image/gallery : portrait of the author
- link : other book from this author
- email : email of the author
- ...


In the detail page of the book I want to show the information of the book and the informations of the author

In the book article author is a select fields created by an sql query giving for the category author, the id and the title of the article for all active articles.

I thought about doing that in the sql query. But it's not quite clever : I duplicate in the book a lot of informations already existing in the author article and if I do a modification in the author article, it won't be showed in the book until I update the book article. So I think I need to do that in the detail page of the book article.


My question : is it possible to get in the detail page for a book all the fields for the linked author which are in the author article ?


thank you for help

best regards

Michel