I've used this many times and it's always worked, however for some reason I'm missing something.
$ddType_query="SELECT DISTINCT Type from dbo.LTN_HARDWARE";
$ddType_result=odbc_exec($conn, $ddType_query);
while ($ddTypeOptionsRows = odbc_fetch_array($ddType_result)) {
//echo $ddTypeOptionsRows['Type'], "\n";
$ddTypeOptions = $ddTypeOptionsRows['Type'] ;
}
odbc_close($conn);
I'm trying to get the $ddTypeOptions to contain all the distinct results of the Type column in LTN_HARDWARE. It's only returning one value and I know there are more.
If I echo $ddTypeOptionsRows it shows correctly so I know it's something with assigning the value to $ddTypeOptions.
Any help would be GREAT!
Thank you.