Syntax error - I can't see it !!

baffled_in_UK

Hi,

I'm getting a syntax error when this script runs and I've spent hours looking at the damn thing. Can anyone spot the error, because I can't. Maybe I've got a case of "snow-blindness"

$sql = "INSERT INTO membersextra
(id,msa,adi,dia,iam,rospa,sim,adv,mot,dis,blk,aut,man,dul,pps,fem,int,ttc,gen,hgv,rac,bik,inf)

VALUES ('$id','$msa','$adi','$dia','$iam','$rospa','$sim','$adv','$mot','$dis','$blk','$aut','$man','$dul','$pps','$fem','$int','$ttc','$gen','$hgv','$rac','$bik','$inf')";

Many thanks
JG

ps. sorry it's laid out so badly, I couldn't get it to display each string on one line, I've attached a .txt file to make it easier to read if anyone wants to see it.

DwarV

this is just one string... where's the rest of the script?
i can't find it either.. maybe there's an error in another part of the script...
the syntax matches with the official mysql syntax....

baffled_in_UK

I use this code to track any errors while I am developing

if (!mysql_query($sql)) {
echo "error:<br>".mysql_error();
die; // stop

and the messageI get is

error:
You have an error in your SQL syntax near 'int,ttc,gen,hgv,rac,bik,inf) VALUES ('21','','','','','','','','','',''' at line 2

does this not mean the error is within the piece of code I posted ?

DwarV

looking at the text you just posted,
i would say, check the contents of
the variables
(especially $blk)
because i think it contains a '
which causes this line:

('21','','','','','','','','','','''

this can't be right...

these ' are ment to act as a separator, so if a variable contains this ' the script will think that there's no more content after the second ' and when it meets a third ' it wil halt..

if you know what i mean.. because it's very difficult for me to describe my thoughts..

baffled_in_UK

I have just "echo"ed the fields and they are all ok.

This is really causing me problems and I'm begining to lose it ! 🙂

The script is large, but I'll attach the bits immediately before it (I know it works because records are written to another table)

baffled_in_UK

solved it...

it didn't like the

int

it's used by

    is_int

to check if a value is an integer.