Hi
I'll try to execute an insert query , if i generate value of my $query , i get 1064 You have an error in your SQL syntax near '' at line 1 , but if i set value of $query directly query process sucessfully getting down.
this code generate value of $query :
$insertvalue->keys='field0,field1,field2,field3,field4,field5,field6,field7,field8,field9';
$insertvalue->values="'6798-1922','SR','2002/4/26','2003/4/26','50000','166.6666666','265',10,'50000',1";
$query="insert into mytable ($insertvalue->keys) values ($insertvalue->values)";
mysql_query($query,$conn);
output :
1064 You have an error in your SQL syntax near '' at line 1
and this code is directly inserting for $query.
$query="insert into services (field0,field1,field2,field3,field4,field5,field6,field7,field8,field9) values ('6798-1922','SR','2002/4/26','2003/4/26','50000','166.6666666','265',10,'50000',1)";
mysql_query($query,$conn);
output :
query successfully done without error.
help me please to solve this problem .
thanks a lot
Sergey
