autopopulate country dropdown list

Welcome, Guest

autopopulate country dropdown list

(1 viewing) (1) Guest

Reply Topic

New Topic

Page:
1

TOPIC: autopopulate country dropdown list

autopopulate country dropdown list 2 years, 10 months ago #7044

morktron
OFFLINE
Fresh Boarder
Posts: 8

Hi, i found the documentation here www.rsjoomla.com/customer-support/docume...st-from-a-table.html about how to auto populate a dropdown.

//<code>
$items = "|Please Select[c]\n";
$rez = mysql_query("SELECT your_value,your_label FROM your_table_here");
while($r = mysql_fetch_assoc($rez))
$items .= $r['your_value'] . '|' . $r['your_label'] . "\n";
return $items;
//</code>

This is fine if you are an accomplished coder but unfortunately I am not.

I've attached a screenshot of my database showing the country list from VirtueMart.

your_table_here - would this be jos_vm_country?

your_label - what is this?

your_value - what is this?

Then do I put this code into 'Additional attributes' in RSForm Pro admin?

Thanks, this is quite exiting for me if it works!

Attachments:

vm_countries.jpg (0KB)
vm_countries.jpg (0KB)

Last Edit: 2 years, 10 months ago by morktron. Reason: trying again

Reply Quote

Re:autopopulate country dropdown list 2 years, 10 months ago #7045

morktron OFFLINE Fresh Boarder Posts: 8	can't seem to attach an image!
	Reply Quote

Re:autopopulate country dropdown list 2 years, 10 months ago #7046

bogdan
OFFLINE
Moderator
Posts: 111

Hello ,

Try this:

//<code>
$items = "|Please Select[c]\n";
$rez = mysql_query("SELECT country_id,country_name FROM #__vm_country");
while($r = mysql_fetch_assoc($rez))
$items .= $r['country_id'] . '|' . $r['country_name'] . "\n";
return $items;
//</code>

Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here

RSJoomla! Development Team

Reply Quote

Re:autopopulate country dropdown list 6 hours, 1 minute ago #0

rsjoomlasupport
OFFLINE
Moderator

Hello,
This is an automatically generated message.
We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you wish to receive our support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here: http://www.rsjoomla.com/support-policy.html.

Thank You!
PLEASE NOTE: This topic is NOT locked and you can add replies to it. Other users are free to reply as well. This message has been generated by a bot and has no effect on the topic whatsoever.

Need help ? Submit a ticket!

Reply Quote