2. PHPRunner General questions
  3. [SOLVED]  Large amount of data in a list box
This topic is locked
[SOLVED]

 Large amount of data in a list box

 		10/6/2010 3:20:30 PM
PHPRunner General questions
K
 karmacomposer author

I have quite a few fields where I will have 20, 30 or more entries. I am choosing lookup wizard.
Is there any way to import a list of data into this so I don't have to enter a zillion entries?
Also, for mundane lists like US States, US Cities and Countries of the world, do pre-made lists exist so I don't have to re-create drop downs every single time?
Thanks.
Mike
Sergey Kornilov admin 10/6/2010

Here is the post that can help you with the list of countries:

http://www.asprunner.com/forums/topic/5608-create-a-table-with-the-list-of-countries/
You can find something similar for the list of US states on Internets.
K
 		karmacomposer author 10/6/2010



Here is the post that can help you with the list of countries:

http://www.asprunner.com/forums/topic/5608-create-a-table-with-the-list-of-countries/
You can find something similar for the list of US states on Internets.


Thank you. That is very useful. SQL beginner question here: Do I run this script in sql somehow (in unix/linux) or is there someplace in php runner that I can copy and paste this into?
Mike
A
 		ann 10/7/2010

Mike,
You can execute script using any MySQL admnistrative tool (phpMyAdmin for example) or run it directly in PHPRunner on the Edit SQL query tab in SQL mode
K
 		karmacomposer author 10/7/2010



Mike,
You can execute script using any MySQL admnistrative tool (phpMyAdmin for example) or run it directly in PHPRunner on the Edit SQL query tab in SQL mode


Great. It worked out with PHPMyAdmin really well (and really easy). I was able to create several necessary tables that way. The lookup feature works well, too.
This one is solved!
Mike