Please help! Need to code multiple rows of dynamic select menu's

Curtis782

I have a MySQL DB containing 2 tables, a part # table and description table. Each table row contains 2 records (id, and input) to match part numbers with their relevant description.

I have a record "add" form with 10 rows, each row containing a select menu for the part #'s and a field for the description.

Scenerio: when a user selects a part # from the pull-down, the relevant description should be printed next to it.

I'd like the part # list to be a dynamic select menu if possible.

How can I do this? I tried looking this up online and tried various code samples but none helped... I am a novice PHP programmer. Any help would be greatly appreciated!

tony_l

I prefer to code this as a function, but here is the basic idea -

PRINT("<SELECT name = 'yourname'>");

$query = "SELECT values FROM sometable WHERE somecondition";

$result = mysql_query($query);

WHILE($item = mysql_fetch_array($result))
{

$value = $item['id'];
$product = $item['product_name'];

PRINT("
<OPTION value = '$value'>$product</OPTION>\n

")

}//end while loop

PRINT("</SELECT>");

I hope that helps you get started. Like I said, I put this into a handy function and put it in a file that I include in all pages that contain forms. I will let you code the function - it is rewarding making your own library of functions that make your own life easier 🙂

Curtis782

Thank you for the advice you gave me so far. Here is a screenshot of what I am trying to accomplish... selecting a part number would then print the relevant description:

http://70.84.139.154/~devsite/wo/screenshot_workorder.gif

I'd like to somehow create the part number and description as 2 separate variables so I can send this info to my database, along with the rest of the workorder data.

I was only able to get so far as the first row in the screenshot (from following a tutorial on the web)... I tried copying my code but it wouldn't populate any of the other select boxes in the remaining rows. As such (and the tutorial code being somewhat complex and not designed for multiple rows as in the screenshot) I'd like to scrap my existing code for something more relevant to what I'm trying to accomplish. I'm not sure if I might need to create some kind of array (which I know nothing about), etc.

Any more help would be very much appreciated. :-)