formfields.com

[JohnConklin]

I need to add multiple drops downs that pull data from my database.

I am trying to use:

function splitResultSet($rs) {
$values1 = array();
$values2 = array();
$i = 0;
while ( ($row = mysql_fetch_array($rs, MYSQL_NUM)) ) {
$values1[$i] = $row[0];
$values2[$i++] = $row[1];
}
return array($values1, $values2);
}

It works for the first one, but won't let me declare this more than once.

How do I create multiple drops downs that pull from different tables?

I want to pull the ID number and Description, but only display the description in my drop down.

Any and all help is greatly appreciated.

Thanks,
~John

[cisco1014]

Why not try this:

$sql_lookup_description = getList("description select statement");
$sql_lookup_id = getList("id select statement");

$formBean->addField(new ListField("description", "Description", REQUIRED, $sql_lookup_description, $sql_lookup_id, "<Select One>", 1);

This will define a dropdown with "id"=>"description"

[note] getList is defined in dbHelpers.php

[JohnConklin]

Thanks for your reply and example.

I found that I can use the same function call if I just declare each item I want to pull from the databaes seperatlly.

So, using this funciton: