wat is er hier fout aan krijg deze code:
CitaatColumn count doesn't match value count at row 1
dit is mijn code
PHP
if($_SERVER['REQUEST_METHOD'] == 'POST')
{
$sTrans['name'] = 'naam';
$sTrans['cats'] = 'categarie';
$sTrans['price'] = 'prijs';
$sTrans['information'] = 'informatie';
$sTrans['picture1'] = 'picture1';
$sTrans['picture2'] = 'picture2';
$sQuery = mysql_query("
INSERT INTO
products
(
pro_sid,
pro_name,
pro_cats,
pro_price,
pro_information,
pro_picture1,
pro_picture2,
pro_remote,
pro_date
)
VALUES
(
'" . mysql_real_escape_string($rowUser['use_id']) . "',
'" . mysql_real_escape_string($_POST['name']) . "',
'" . mysql_real_escape_string($_POST['cats']) . "',
'" . mysql_real_escape_string($_POST['price']) . "',
'" . mysql_real_escape_string($_POST['information']) . "',
'" . mysql_real_escape_string($_POST['picture1']) . "'
'" . mysql_real_escape_string($_POST['picture2']) . "'
'" . mysql_real_escape_string($_SERVER['REMOTE_ADDR']) . "',
NOW()
)
");
if(mysql_error())
{
echo mysql_error();
}
else
{
echo $_POST['name'],'is ctoeveg';
}
}
}
?>
Toon Meer