Anomaly , mysql insert doesnt work

[rwhite35]

Instead of the literal and double quotes, try it with just the literals.

Code: Select all

$Inkelti = mysql_query("INSERT INTO `Ieskomi`(ID, VardasPavarde, GimimoMetai, Salys, Miestas, Lytis, Dingo, Apibudinimas, Nuotrauka, Statusas, KadaInkele, Inkele)
         VALUES(NULL, '$VardasPavarde', '$GimimoMetai', '$Salys', '$Miestas', '$Lytis' '$Dingo', '$Apibudinimas', '$Nuotrauka', '$Statusas', '$DATA', '$Inkele')");

Also if the column tab order is the same as your value list, you can shorten the INSERT statement to:

Code: Select all

$Inkelti = mysql_query("INSERT INTO `Ieskomi` VALUES('', '$VardasPavarde', '$GimimoMetai', '$Salys', '$Miestas', '$Lytis' '$Dingo', '$Apibudinimas', '$Nuotrauka', '$Statusas', '$DATA', '$Inkele')");

Note that the first value (ID) is empty. This assumes you are auto_incrementing the column. Finally, you should consider using prepared statements instead mysql_* functions.

Good luck