TOPIC:

populate a fieldlist with joomla articles title 2 years 7 months ago #234944

  • greg.o
  • Offline
  • Junior Breezer
  • Junior Breezer
  • Posts: 49
  • Thanks: 0
Great! Great! Thank you, it works perfectly!

Just one more question, can you make the title disappear when the article is disabled?

Thank you!

Please Log in or Create an account to join the conversation.

populate a fieldlist with joomla articles title 2 years 6 months ago #234996

  • mihaela
  • Offline
  • Developer
  • Developer
  • Posts: 3128
  • Karma: 105
  • Thanks: 415
Hello again,

I'm glad that the suggested solution is working for you. :)

As for showing only the published articles, a condition should be added to the query.

So, the query:
$db->setQuery('Select title From #__content Where catid=2 OR catid=3');
should be replaced with this one:
$db->setQuery('Select title From #__content Where catid=2 OR catid=3 AND state =1');
since published articles should have state 1.

Let me know whether this solution works as you wanted.

Regards,

Mihaela

Please Log in or Create an account to join the conversation.

populate a fieldlist with joomla articles title 2 years 6 months ago #234998

  • greg.o
  • Offline
  • Junior Breezer
  • Junior Breezer
  • Posts: 49
  • Thanks: 0
Oh thank you very much!

It was very simple :-/

Sorry!

Please Log in or Create an account to join the conversation.

populate a fieldlist with joomla articles title 2 years 6 months ago #235005

  • mihaela
  • Offline
  • Developer
  • Developer
  • Posts: 3128
  • Karma: 105
  • Thanks: 415
Hello again,

No problem, the important thing is that it is now working. :)

Regards,

Mihaela
The following user(s) said Thank You: greg.o

Please Log in or Create an account to join the conversation.

populate a fieldlist with joomla articles title 2 years 6 months ago #235126

  • greg.o
  • Offline
  • Junior Breezer
  • Junior Breezer
  • Posts: 49
  • Thanks: 0
Thank you again very much for your help!

I'll have one more small request. I would like to add the date of creation of the article.

I added: $db->setQuery('Select title, created From #__content Where catid=2 OR catid=3 AND state =1');

But it does not display the date. Should I add elsewhere in the code?

Please Log in or Create an account to join the conversation.

populate a fieldlist with joomla articles title 2 years 6 months ago #235128

  • mihaela
  • Offline
  • Developer
  • Developer
  • Posts: 3128
  • Karma: 105
  • Thanks: 415
Hello again,

I am glad to help.

As for the adding info about created, would you like that to be displayed in the list next to the title or where would you like to put it?
Also, should the creation date also be saved to the record when a certain option is selected or you want to have only the name saved?

Regards,

Mihaela
The following user(s) said Thank You: greg.o

Please Log in or Create an account to join the conversation.

Moderators: ForumSupport
Time to create page: 0.057 seconds

BreezingForms Pro 1.4.7 for WordPress Released!

Available in the membership section.

September Discount!

Massive discounts on all subscriptions!

Get Your Subscription Here

Quick Links

Downloads

BreezingForms

ContentBuilder

BreezingCommerce

Templates

Documentation

BreezingForms

ContentBuilder

BreezingCommerce

Apprendre BreezingForms (French Community)

Apprendre et maîtriser BreezingForms par des tutoriels et exemples, le tout en français

breezingforms.eddy-vh.com

Questions et réponses sur les forums de l'AFUJ

AFUJ

Special Offer

Summer Sale! All subscriptions at a special price!

Includes prio support, all of our current and future Joomla!® extensions and Joomla!® templates for the duration of your membership.

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!