Database ---> insert date doesn t work :/
Posted: Thu Oct 09, 2003 10:39 am
Hi..
This works really good
but when i try to add the date (wich on my form page is automatically filled) it s just doesn t work
so if i change my previous query by this
i got an error :
SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement., SQL state 37000 in SQLExecDirect...
btw my date goes like this
This works really good
Code: Select all
<?php
$connect = odbc_connect("tech_support", "kader", "edh") or die("Connection failed");
$query = "SELECT key FROM Clients";
$queryexe = odbc_do($connect, $query);
while(odbc_fetch_row($queryexe))
{
$varkey = odbc_result($queryexe, 1);
}
$date = $_POST["days"]."-".$_POST["months"]."-".$_POST["years"];
$nom = $_POST["nom"];
$centre = $_POST["centre"];
$phone = "(".$_POST["indicatif"].")"." ".$_POST["phone1"]."-".$_POST["phone2"];
$person = $_POST["person"];
$serial = $_POST["serial1"]." ".$_POST["serial2"]." ".$_POST["serial3"];
$machine = $_POST["machine"];
$ftp = $_POST["ftp"];
$fta = $_POST["fta"];
$tp = $_POST["tp"];
$key1 = $_POST["key1"];
$key2 = $_POST["key2"];
$key3 = $_POST["key3"];
$garantie = $_POST["garantie"];
$problem = $_POST["problem"];
$var = $varkey;
if ($var == "NULL") {
$var == 1;
}else{
$var++;
}
echo ("<tr align='center' class='textegris'>");
//echo ("<td>$date</td>");
echo ("<td>$centre</td>");
echo ("<td>$nom</td>");
echo ("<td>$phone</td>");
echo ("<td>$person</td>");
echo ("<td>$machine</td>");
echo ("<td>$garantie</td>");
echo ("<td>$var</td>");
echo ("</tr>");
odbc_close($connect);
$connect = odbc_connect("tech_support", "kader", "edh") or die("Connection failed");
$query = "INSERT INTO Clients ( centre, nom, phone, Derniere, machine, garantie, key) VALUES ( '$centre', '$nom', '$phone', '$person', '$machine', '$garantie', '$var')";
$queryexe = odbc_do($connect, $query);
odbc_close($connect);
?>so if i change my previous query by this
Code: Select all
<?php
$query = "INSERT INTO Clients ( date, centre, nom, phone, Derniere, machine, garantie, key) VALUES ( '$date', '$centre', '$nom', '$phone', '$person', '$machine', '$garantie', '$var')";
?>SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement., SQL state 37000 in SQLExecDirect...
btw my date goes like this
Code: Select all
<input name="days" type="text" class="date" maxlength="2" value="<?=date("d")?>" />
/
<input name="months" type="text" class="date" maxlength="2" value="<?=date("m")?>" />
/
<input name="years" type="text" class="date" maxlength="2" value="<?=date("y")?>" />