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, 5 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, 5 months ago by jurgen0.

Re: Populate select list with article titles 1 year, 5 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: 527
  • Karma: 8

Re: Populate select list with article titles 1 year, 5 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, 5 months ago by jurgen0.

Re: Populate select list with article titles 1 year, 5 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: 527
  • Karma: 8

Re: Populate select list with article titles 1 year, 5 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, 5 months ago #16780

Hi Jurgen!

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

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

About

Crosstec GmbH & Co. KG

Bergisch-Gladbacher-Str. 829

51069 Cologne, Germany