I'm trying to get an .xml
feed using PHP but the problem is with selecting the data from the SQL Server database.
$version = mssql_query('SELECT tabVozy.[Číslo vozu] AS WagonNumberFreight FROM [RykoPlus].[dbo].[tabVozy]');
The result of this query is: bool(false)
.
I identified that the problem lies in the Czech column name ('Číslo vozu'). When I tried
SELECT tabVozy.[Majitel] AS OwnerCompanyCode
FROM [RykoPlus].[dbo].[tabVozy]
It was perfectly fine.
Is there a way to handle the column name? I can not rename these columns.