I'm always making my inserts like this:
$Insert = "INSERT INTO basket_db (name, image_id, customer_id, session_id)
";
$Insert .= "VALUES ('$name', '$image_id', '$customer_id', '$PHPSESSID')";
...and I'm using the SET Field = '$Value' in the Update Querys like this:
$UpdateQuery = "UPDATE produk
Tim's right about NULL. You can either specify what exactly are the
fields of the row you want to update/insert using SET before VALUE (seek
the manual at www.mysql.com for more info) or you can just write NULL
(without any quotes) where the fields are automatic like
*auto_increment* or like *time
2 matches
Mail list logo