Welcome, Guest

Populate select list with article titles
(1 viewing) (1) Guest
  • Page:
  • 1
  • 2

TOPIC: Populate select list with article titles

Populate select list with article titles 1 year, 9 months ago #16385

I think my problem has a simple solution, I hope someone can help me...

I'm using Quickmode and I want to create a select list with article titles from a selected category.

I have a query:

$sql = "SELECT title FROM jos_content WHERE catid=36 ORDER BY jos_content.ordering ASC";


and I want to show the result in a select list.

Hope someone can help me....
  • jurgen0
  • OFFLINE
  • Fresh Boarder
  • Posts: 5
  • Karma: 0
Last Edit: 1 year, 9 months ago by jurgen0.

Re: Populate select list with article titles 1 year, 9 months ago #16421

Hi Jurgen0,

Take a look at this KnowledgeBase article and see if it helps you:

crosstec.de/support/index.php?pid=knowle...wentclient&id=52

Terry
  • terrywmu
  • OFFLINE
  • Administrator
  • Posts: 510
  • Karma: 8

Re: Populate select list with article titles 1 year, 9 months ago #16422

Hi Terry,

Thank you for your reply.

Ofcourse I've searched through the KB and the forum, but whatever I try, I can't get it to work. If I create a separate PHP file (www.webserver-install.com/digitaalcentrum/test.php) and put my code in it, it works. But I'm not able to translate it to Breezingforms.

Jurgen.

<?php
$link = mysql_connect("localhost", "root", "1979N1");
mysql_select_db("digitaalcentrum", $link);

$query = "SELECT title, ordering FROM jos_content WHERE catid=36 ORDER BY jos_content.ordering ASC";
$results = mysql_query($query, $link) or die("Error performing query");

if(mysql_num_rows($results) > 0){
echo("<select name=\"selectItem\">");
while($row = mysql_fetch_object($results)){
echo("<option value=\"$row->record_id\">$row->title</option>");
}
echo("</select>");
}
else{
echo("<i>No values found</i>");
}
?> 
  • jurgen0
  • OFFLINE
  • Fresh Boarder
  • Posts: 5
  • Karma: 0
Last Edit: 1 year, 9 months ago by jurgen0.

Re: Populate select list with article titles 1 year, 9 months ago #16424

I see that you have a subscription. Can you please send a support request through to us via this form:

crosstec.de/crosstec-support-request

Then we can have your issue addressed by one of the programmers (who knows a lot more about this than I do!).

Thanks,

Terry
  • terrywmu
  • OFFLINE
  • Administrator
  • Posts: 510
  • Karma: 8

Re: Populate select list with article titles 1 year, 9 months ago #16425

Hello Terry,

I already did, but I need it fast and the support team has a backlog. So I hoped someone over here could help me.

Jurgen.
  • jurgen0
  • OFFLINE
  • Fresh Boarder
  • Posts: 5
  • Karma: 0

Re: Populate select list with article titles 1 year, 8 months ago #16780

Hi Jurgen!

Use Classic-Mode. There you have an item for a querylist..

matthias
  • goshmac
  • OFFLINE
  • Expert Boarder
  • Posts: 113
  • Karma: 5
  • Page:
  • 1
  • 2
Moderators: TheMuffinMan, ForumSupport
Time to create page: 0.55 seconds

Facebook Discount - 40% Off!

Fans of our Facebook page here are entitled to get a 1-year-subscription for the price of a 6-months!

Steps to take:

  • Become a fan on Facebook (Like) here
  • Purchase a 6-months-subscription from here
  • Write a quick email to This email address is being protected from spambots. You need JavaScript enabled to view it. with your username and prove of your like and we'll upgrade to the 1-year-subscription

Joomla!® Forms Discount - 40% Off!

Already purchased a forms extension from a different vendor but your requirements changed and now you need a forms extension that is capable of more than just the standards? We help you to keep the costs for a change under control: Get a 40% discount on our professional membership plan! -- meaning timely unlimited access to all current and future commercial extensions, breezingforms themes & apps and Joomla!® templates at crosstec.de, including 1 year of support -- without any website limitations -- Just prove that you previously purchased another forms extension for Joomla!® from a different vendor and you are qualified.

Steps to take:

  • Purchase a 1-year-subscription from here
  • Write a quick email to This email address is being protected from spambots. You need JavaScript enabled to view it. with your username and prove of the purchase for the other form vendor and we'll upgrade to the professional-subscription

About

Crosstec GmbH & Co. KG

Bergisch-Gladbacher-Str. 829

51069 Cologne, Germany

Imprint