Welcome Guest, Not a member yet? Register   Sign In
SQL query
#4

HI,

I want to select station_nom, kpi_cate, kpi_nom, kpi_valeur, kpi_date, kpi_heure into the table kpi between two dates. I show you my controller and my model that I wrote. Unfortunately, my request generates the error below:

Error Number: 1064

Erreur de syntaxe près de '`NULL` AND `kpi_date` > `IS` `NULL`' à la ligne 10

SELECT `station_nom`, `kpi_cate`, `kpi_nom`, `kpi_valeur`, `kpi_date`, `kpi_heure` FROM `kpi` JOIN `station_base` ON `station_base`.`station_id` = `kpi`.`station_id` WHERE `type_reseau` IS NULL AND `kpi_type` IS NULL AND `region` IS NULL AND `ville` IS NULL AND `centre` IS NULL AND `site` IS NULL AND `kpi_date` < `IS` `NULL` AND `kpi_date` > `IS` `NULL`

Filename: C:/wamp/www/CodeIgniter/system/database/DB_driver.php

Line Number: 691
Reply


Messages In This Thread
SQL query - by ben beker - 05-26-2018, 07:52 AM
RE: SQL query - by hipm - 05-26-2018, 09:35 PM
RE: SQL query - by ben beker - 05-28-2018, 12:42 AM
RE: SQL query - by ben beker - 05-29-2018, 12:20 AM



Theme © iAndrew 2016 - Forum software by © MyBB