This topic is locked

date error msg

2/3/2009 12:21:43 AM
PHPRunner General questions
F
faba2020 author

PHP Return Error Msg
Error type 256

Error description Incorrect date value: '2005' for column 'date' at row 1
Error line 34

SQL query insert into sellstock (id,stockqty,proid,date) values (5,20,2,2009-02-02)
After Record Added Even
$seq=$values["stockseq"];
$qty=$values["stockqty"];
$product=$values["stockproid"];
$date=$values["stockdate"];
global $conn;
$strSQLInsert = "insert into sellstock (ssseq,ssstockqty,ssproid,ssdate) values (".$seq.",".$qty.",".$product.",".$date.")";
db_exec($strSQLInsert,$conn);
return false;

J
Jane 2/3/2009

Hi,
you need to add single quotes around text and date values in your SQL query:

$strSQLInsert = "insert into sellstock (ssseq,ssstockqty,ssproid,ssdate) values (".$seq.",".$qty.",".$product.",'".$date."')";