Member_2_5230414
asked on
unable to solve You have an error in your SQL syntax;
Im trying to add value into my database and i keep getting the following error "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 '','','4','Telegraph (IRE)','3','9-3','','57',' Evans, P D','28/1 ','Egan, John '' at line 1"
my query looks like this
mysqli_query($db,"INSERT INTO `Horses` (`Date`,`Track`,`Runners`, `Going`, `Distance`,`Class`,`Place` ,`Losing_D ist`,`Stal l`,`Horse` ,`Age`,`We ight`,`Hea dgear`,`Ho rse_OR`,`T rainer`,`O dds`,`Jock eys_Claim` ,`Comments `,`Race_Na me` )VALUES ('$date','$place','$norunn er','$goin g','$dista nce','$cla ss',$place ','$distan ce_bt','$s tall','$ho rse','$age ','$weight ','$headge ar','$OR', '$trainer' ,'$odds',' $jockey',' $comments' ,'$event') ")or die(mysqli_error($db));
and my table looks like this:
Column Type Null Default
ID int(255) No
Date varchar(250) Yes NULL
Track varchar(100) Yes NULL
Runners varchar(50) Yes NULL
Going varchar(50) Yes NULL
Distance varchar(50) Yes NULL
Class varchar(50) Yes NULL
Place varchar(10) Yes NULL
Losing_Dist varchar(50) Yes NULL
Stall varchar(250) Yes NULL
Horse varchar(50) Yes NULL
Age varchar(50) Yes NULL
Weight varchar(50) Yes NULL
Headgear varchar(50) Yes NULL
Horse_OR varchar(50) Yes NULL
Trainer varchar(50) Yes NULL
Odds varchar(50) Yes NULL
Jockeys_Claim varchar(50) Yes NULL
Comments varchar(250) Yes NULL
Race_Name varchar(250) Yes NULL
my query looks like this
mysqli_query($db,"INSERT INTO `Horses` (`Date`,`Track`,`Runners`,
and my table looks like this:
Column Type Null Default
ID int(255) No
Date varchar(250) Yes NULL
Track varchar(100) Yes NULL
Runners varchar(50) Yes NULL
Going varchar(50) Yes NULL
Distance varchar(50) Yes NULL
Class varchar(50) Yes NULL
Place varchar(10) Yes NULL
Losing_Dist varchar(50) Yes NULL
Stall varchar(250) Yes NULL
Horse varchar(50) Yes NULL
Age varchar(50) Yes NULL
Weight varchar(50) Yes NULL
Headgear varchar(50) Yes NULL
Horse_OR varchar(50) Yes NULL
Trainer varchar(50) Yes NULL
Odds varchar(50) Yes NULL
Jockeys_Claim varchar(50) Yes NULL
Comments varchar(250) Yes NULL
Race_Name varchar(250) Yes NULL
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
:-)
Sometimes a fresh pair of eyes is all that is needed. Thanks for the points and enjoy your lunch
Sometimes a fresh pair of eyes is all that is needed. Thanks for the points and enjoy your lunch
ASKER