Nope, all my values are strings.
Markas [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED];
$SQLString = INSERT INTO Movies (Title, Actors, Review, Reviewer, Short)
VALUES ('$Title','$Actors','$Review','$Reviewer','$Short');
As the manual says: Note: Unlike the two other syntaxes,
Does any of your values has an apostrophe in them? If
there is, you will get a syntax error
Hope this helps,
Harry
__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sportsyahoocom
--
PHP General Mailing List
Matt Schroebel suggested I
echo $SQLString;
The echo statement returned
INSERT INTO Movies (Title, Actors, Review, Reviewer, Short) VALUES (, , , ,
,)
So, clearly, the error lies in the form that passes the values to this
script.
Thanks Matt, we're getting closer.
Dr. Shim [EMAIL
OK. Is Short a keyword? The Short part in INERT INTO Movies (Title,
Actors, Review, Reviewer, Short) is giving me the Syntax Error
message.
I will rename my tables with a mv suffix. Lets see if that solves the
problem.
Dr. Shim [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED];
$SQLString = INSERT INTO Movies (Title, Actors, Review, Reviewer, Short)
VALUES ('$Title','$Actors','$Review','$Reviewer','$Short');
As the manual says: Note: Unlike the two other syntaxes, variables will not
be expanded when they occur in single quoted strings. ... So maybe some your
fiels
I've tried, and tried Reread, and reread I can't at all find out what's
wrong with these two lines of code
$SQLString = INSERT INTO Movies (Title, Actors, Review, Reviewer, Short)
VALUES ('$Title','$Actors','$Review','$Reviewer','$Short');
$cursor = odbc_exec($db, $SQLString);
I have an
Well, add this and tell us what it says:
if(!$cursor) echo odbc_error($db): odbc_errormsg($db);
right after that odbc_exec() call
*always check for errors - and when you get one, show it!*
-Rasmus
On Sat, 2 Mar 2002, Dr Shim wrote:
I've tried, and tried Reread, and reread I can't at all
I did, and a rather informative error message came. I didn't know how to
debug like that. Sorry, I'm rather new to this.
It says [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT
INTO statement.
Rasmus Lerdorf [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED];
Well,
8 matches
Mail list logo
