Forum Discussion

Copper Contributor

Jun 11, 2022

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

Bronze Contributor

Jun 13, 2022

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]";