I am banging my head here, I need to execute a SQL query via PHP & ODBC against a table with a repeating field and get the results of the field. Right now, when I execute a query such as
SELECT rptField from TABLE WHERE id='123ABC'
I get only the first entry of the repeating field. How can I get all of the entries?