Drop down w/multiple columns

[RPGguy]

I checked FAQ and came up empty so here goes:

I would like a drop down list showing 2 rows from my Customer table(customer number and name). When the user clicks I would like to return only the customer #. I'm using PHP, mySQL and HTML.

Thanks in advance for your help.

Scott

 

[MikeBronner]

If you want to have lists with multiple columns, you will have to use ActiveX or Flash objects (or something similar). This can't be done in HTML. A work-around would be to generate the select list using padded PHP variables:

<select>
    <option value=&quot;<?= $strCustNum ?>&quot;><?= str_pad($strCustNum, 10, ' ', STR_PAD_LEFT) . ' ' . $strCustName ?></option>
</select>

Keep in mind that 10 represents the total length of the string, including padding, so make sure that that number is always greater than the largest number has digits.

Hope this helps.

Take Care,
Mike

 

[RPGguy]

Thanks Mike. I'm not clear though on what gets returned. Is it the customer # only or the whole string. If it's the string I assume I would have to parse out the number.

 

[MikeBronner]

The only value that gets returned to the next page is whatever you decide to put in the value attribute of the option tag:

<option value=&quot;this gets returned&quot;>This does not get returned if value attribute is included</option>

Good luck

Take Care,
Mike