MySQL Forums

Hi,

I am developing small web app for accouters, I am stacked with this recipes insert form using mysql query = insert into. from phpmyadmin it works fine, but from web it is not inserting right;

here is the code;
<?php

require('db.php');

// Create the variables
$ceksNR = $_POST["ceksNR"];
$konts = $_POST["konts"];
$apraksts = $_POST["apraksts"];
$piegadatajs = $_POST["piegadatajs"];
$datums = $_POST["datums"];
$PVN = $_POST["PVN_%"];
$summa_ar_PVN = $_POST["summa_ar_PVN"];
// Inserts the data into the database
$result= MYSQL_QUERY(
"INSERT INTO recipes (dokumenta_ID, ceksNR, konts, apraksts, piegadatajs, datums, PVN_%, summa_ar_PVN)".
"VALUES ('', '$ceksNR', '$konts', '$apraksts', '$piegadatajs', '$datums', '$PVN', '$summa_ar_PVN')"
);
echo "Paldies, dokuments jūsu dokuments Nr. $ceksNR ir piereģistrēts datu bāzē.";
?>
and html form
<form action="vaicajumi/datainserttest.php" method="post">

Kases čeka nummurs:<br />
<input name="ceksNR" type="text" /><br />

Izdevumu konts:<br />
<input name="konts" type="text" /><br />

Izdevumu apraksts <br />(ievadiet atbilstošu kategoriju):<br />
<input name="apraksts" type="text" /><br />

Piegadatajs:<br />
<input name="piegadatajs" type="text" /><br />

Datums (gads.mēn.diena):<br />
<input name="datums" type="text" /><br />

PVN (%):<br />
<input name="PVN_%" type="text" /><br />

Ievadiet pirkuma summu ar PVN:<br />
<input name="summa_ar_PVN" type="text" /><br />

<input type="submit" />

</form>
Maybe I am doing something wrong? from my side it looks right and it should work.

Any suggestions
Thanks

Janis