Comments by Ivan Sepulveda

Ivan Sepulveda 18-Jan-23 10:50am View

I added double quotes for my date and now complains in #1064 - 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 '@gmail.com,baby, chief,nunoa,940429390,2016,4toB,ssss, 2022,6 F,ssss,test, "2...' at line 1

Ivan Sepulveda 18-Jan-23 10:46am View

PHPADMIN: MySQL said: Documentation

#1064 - 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 '@gmail.com,baby, chief,nunoa,940429390,2016,4toB,ssss, 2022,6 F,ssss,test, 23...' at line 1

Ivan Sepulveda 18-Jan-23 10:44am View

I use variables for my Inserts/updates...I previouly sent the contents of the variables: $sql="INSERT INTO `liceo1`(`rut`, `admin`, `lname`, `fname`, `password`, `email`, `work`,
`profesion`, `ciudad`, `phone`, `yearin`, `cursoin`, `profein`,
`yearout`, `cursoout`, `profeout`, `comments`, `created`)
VALUES ($rutv,$admin,$lname,$fname,$pwd,$email,$work,
$grado,$ciudad,$phone,$yin,$cursoin,$profein,
$yout,$cursoout,$profeout,$story, $date )";
$date=$date = date('y/m/d h:i:s');
echo INSERT INTO `liceo1`(`rut`, `admin`, `lname`, `fname`, `password`, `email`, `work`, `profesion`, `ciudad`, `phone`, `yearin`, `cursoin`, `profein`, `yearout`, `cursoout`, `profeout`, `comments`, `created`) VALUES (208090801,0,Sepulveda,Lautaro,Qwert1234,test@gmail.com,baby, chief,nunoa,940429390,2016,4toB,ssss, 2022,6 F,ssss,test, 23/01/18 04:39:35 )

Comments by Ivan Sepulveda (Top 3 by date)