if two or more columns of the result have the same field names the last column will take precedence to access the other columns of the same name you must use fbsql _ fetch _ array and have it return the numeric indices as well 