The select statement is not obtaining this information ...

You might peek in the functions_lookups.php as I believe I have a look-up function in there for manufacturer ...

You could modify the select statement but that is another table or 2 to connect and relate and make a mess of things where the function would just run the 20 odd times based on the display of the page ...