Forum Discussion
MouradSahbeni
Jun 11, 2022Copper Contributor
problem displaying data in php form
Hello everyone, I am creating a page where I want to display a table containing the data of a sql server 2017 table. The problem is I cannot display them.. Can anyone help me solve this problem? he...
olafhelper
Jun 13, 2022Bronze Contributor
MouradSahbeni , your SQL statement is more the a bit wrong and will cause errors. If an object name contains special characters, even simple spaces, you must set them in brackets, see below.
Better avoid spaces in object name.
$tsql = "SELECT [Code à Barres],
Article,
Désignation,
[Quantité par Unité],
[Quantité Totale],
Groupe2,
Propriété3,
OF,
NUMORDRE,
NUMPALETTE
FROM phils.[Ligne Livraison Client réf]";