Going Crazy

[9amwhiskey]

Maybe I'm missing something here, but can anyone see a problem with the following insert syntax:

"INSERT INTO people (name,age,address) VALUES('$name','$age','$address')";

All I get is: "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 'age,address) VALUES('mike','35','60 Main Street')' at line 1"

Line one is <?PHP

I'm getting really frustrated with how simple this should be

 

[cLFlaVA]

probably something with your data. print the values of your three variables.

also, you should consider using mysql_real_escape_string().



*cLFlaVA
----------------------------
[tt]"quote goes here"[/tt]
[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[jpadie]

just an off thought, have you tried adding a space after the word VALUES?

your data looks fine in this case.

 

[9amwhiskey]

data is good i think.....i echo the sql statement and things look fine. tried the space suggestion, unfortunately to no success. this is so odd. at any rate, i appreciate the advice

 

[jpadie]

you may be better off in the mysql forum. but for a quickie, post your data schema here

 

[Stretchwickster]

Have you tried executing the echoed SQL statement away from PHP?

Clive

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"To err is human, but to really foul things up you need a computer." (Paul Ehrlich)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
To get the best answers from this forum see: faq102-5096