PHP Developers Network
http://forums.devnetwork.net/

How to Display Individual Tables in Dropdowns from SQL?
http://forums.devnetwork.net/viewtopic.php?f=1&t=143190
Page 1 of 1

Author:  sarojthapa60 [ Mon Dec 05, 2016 11:56 am ]
Post subject:  How to Display Individual Tables in Dropdowns from SQL?

I have 5 dropdowns on a tab of a website. I have a database table in MS SQL Server. The table has all the data of 5 dropdowns with one of the fieldNames called Region_Name, say the Region_Names are A, B, C, D, and E. I have written codes to display a table and enabled row editing for one of the RegionNames. Now, I am wondering if I could modify the same codes to display associated table with row editing enabled using different queries when a dropdown is clicked. That could reduce the code repetition and improve the performance. But I do not know how to achieve this. Could anyone please give me some hints? I am using PHP PDO to connect to the database.

** Moved to PHP Code **

Author:  Celauran [ Mon Dec 05, 2016 12:53 pm ]
Post subject:  Re: How to Display Individual Tables in Dropdowns from SQL?

Are the field names the same? Could you pass the table name in as a parameter to the method you're calling? Hard to be more specific without seeing your existing code or the table schemas.

Page 1 of 1 All times are UTC - 5 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/