您的SQL语法有错误 - 无法找到错误[关闭]

Question

I seems to have a sytax error within my code but cannot see why.

the line in question is here:

mysqli_query($db,"INSERT INTO `horses` (`ParentID`,`Date`,`Track`,`Runners`, `Going`, `Distance`,`Class`,`Place`,`Losing_Dist`,`Stall`,`Horse`,`Weight`,`Trainer`,`Odds`,`Oddsmovement`,`Jockeys_Claim`,`Comments`,`Race_Name` )VALUES  ('$id ',' $Thedate','$thecourse','$noinrace','$going','$distance','$class','$place','$distance_bt','$stall','$horse','$weight','$thetrainer','$odds','$oddsmovement','$thejockey','$comments','$event')")or die(mysqli_error($db));

And the full error i get is here

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Meara ',' 22/1 ','25/1 < 22/1','D Nolan','',' Royal Marines ' at line 1

The line in which it says is near is this: '$thetrainer','$odds','$oddsmovement','$thejockey'

the database is set so all fields are varchat(250) aparent from parent id and id which are int

any further information please let me know

Answer 1

This should work if the values in your PHP variables are valid:

mysqli_query($db,"INSERT INTO horses (Date,Track,Runners,Going,Distance,Class,Place,Losing_Dist,Stall,Horse,Weight,Trainer,Odds,Oddsmovement,Jockeys_Claim,Comments,Race_Name) VALUES  ({$Thedate},{$thecourse},{$noinrace},{$going},{$distance},{$class},{$place},{$distance_bt},{$stall},{$horse},{$weight},{$thetrainer},{$odds},{$oddsmovement},{$thejockey},{$comments},{$event})")or die(mysqli_error($db));

Like mentioned in the comments above if this is a public page you should protect again SQL injection there are several techniques just google it if you aren't sure how.