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 PR
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 PROTE
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://sports.yahoo.com
--
PHP General Mailing List (http://www.ph
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 synta
$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
fiel
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].;
Wel
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 a
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
8 matches
Mail list logo
