SELECT * FROM PageCategories WHERE PageMainCategoryID =
SELECT * FROM PageCategories WHERE PageMainCategoryID =
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 Bestand " /home/bzn/domains/bzn.be/public_html/pages/widget_page_category.php " veroorzaakt een fout bij
klant .
Functie aanroep bestand /home/bzn/domains/bzn.be/public_html/pages/widget_page_category.php op lijn 10
Implementatie bestand /home/bzn/domains/bzn.be/public_html/pages/customer_settings.php op lijn 315
SELECT
Dummies.*,
DummieCategories.Name as CategoryName,
DummieMainCategories.Name as MainCategoryName,
DummieMainCategories.DummieMainCategoryID AS MainCategoryID
FROM Dummies
LEFT JOIN DummieCategories ON DummieCategories.DummieCategoryID = Dummies.DummieCategoryID
LEFT JOIN DummieMainCategories ON DummieMainCategories.DummieMainCategoryID = DummieCategories.DummieMainCategoryID WHERE Dummies.OnWebsite = 1 AND Dummies.PageCategoryID = ORDER BY Dummies.DateAdd DESC
SELECT
Dummies.*,
DummieCategories.Name as CategoryName,
DummieMainCategories.Name as MainCategoryName,
DummieMainCategories.DummieMainCategoryID AS MainCategoryID
FROM Dummies
LEFT JOIN DummieCategories ON DummieCategories.DummieCategoryID = Dummies.DummieCategoryID
LEFT JOIN DummieMainCategories ON DummieMainCategories.DummieMainCategoryID = DummieCategories.DummieMainCategoryID WHERE Dummies.OnWebsite = 1 AND Dummies.PageCategoryID = ORDER BY Dummies.DateAdd DESC
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY Dummies.DateAdd DESC' at line 8 Bestand " /home/bzn/domains/bzn.be/public_html/frontend/flexibles/dummies.php " veroorzaakt een fout bij
klant .
Functie aanroep bestand /home/bzn/domains/bzn.be/public_html/frontend/flexibles/dummies.php op lijn 110
Implementatie bestand /home/bzn/domains/bzn.be/public_html/pages/widget_page_category.php op lijn 327
SELECT
Dummies.DummieID,
DummiePhotos.*,
RepositoryFiles.RepositoryDirectoryID,
RepositoryFiles.Name as FileName,
RepositoryFiles.Width,
RepositoryFiles.Height,
RepositoryFiles.Extension,
RepositoryFiles.ResizeSizes,
RepositoryFiles.OriginalResized,
RD.Name AS DirName,
IF (JD.RepositoryDirectoryID IS NULL, RD.Name, CONCAT(JD.Name,'/',RD.Name)) AS FolderName,
RD.RepositoryDirectoryID AS CurrentDirID,
JD.RepositoryDirectoryID AS ParentDirIDName
FROM Dummies
INNER JOIN DummiePhotos ON DummiePhotos.DummieID = Dummies.DummieID
INNER JOIN RepositoryFiles ON DummiePhotos.RepositoryFileID = RepositoryFiles.RepositoryFileID
INNER JOIN RepositoryDirectories AS RD ON RepositoryFiles.RepositoryDirectoryID = RD.RepositoryDirectoryID
LEFT JOIN RepositoryDirectories AS JD ON RD.ParentID = JD.RepositoryDirectoryID
WHERE Dummies.OnWebsite = 1 AND Dummies.PageCategoryID = ORDER BY DummiePhotos.Position
SELECT
Dummies.DummieID,
DummiePhotos.*,
RepositoryFiles.RepositoryDirectoryID,
RepositoryFiles.Name as FileName,
RepositoryFiles.Width,
RepositoryFiles.Height,
RepositoryFiles.Extension,
RepositoryFiles.ResizeSizes,
RepositoryFiles.OriginalResized,
RD.Name AS DirName,
IF (JD.RepositoryDirectoryID IS NULL, RD.Name, CONCAT(JD.Name,'/',RD.Name)) AS FolderName,
RD.RepositoryDirectoryID AS CurrentDirID,
JD.RepositoryDirectoryID AS ParentDirIDName
FROM Dummies
INNER JOIN DummiePhotos ON DummiePhotos.DummieID = Dummies.DummieID
INNER JOIN RepositoryFiles ON DummiePhotos.RepositoryFileID = RepositoryFiles.RepositoryFileID
INNER JOIN RepositoryDirectories AS RD ON RepositoryFiles.RepositoryDirectoryID = RD.RepositoryDirectoryID
LEFT JOIN RepositoryDirectories AS JD ON RD.ParentID = JD.RepositoryDirectoryID
WHERE Dummies.OnWebsite = 1 AND Dummies.PageCategoryID = ORDER BY DummiePhotos.Position
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY DummiePhotos.Position' at line 20 Bestand " /home/bzn/domains/bzn.be/public_html/frontend/flexibles/dummies.php " veroorzaakt een fout bij
klant .
Functie aanroep bestand /home/bzn/domains/bzn.be/public_html/frontend/flexibles/dummies.php op lijn 185
Implementatie bestand /home/bzn/domains/bzn.be/public_html/frontend/flexibles/dummies.php op lijn 114| | Bond Zonder Naam