Re: A Small Bug Giving Me A Big Headache

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" <rasmus@lerdorf.ca> wrote in message news:Pine.LNX.4.44.0203021847290.27428-100000@christine.ca... 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 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 if...then conditional statement causing echo to print out an error > message if the $cursor returns false. > > The $cursor keeps returning false. I don't know why! My $db variable (which > plugs into the odbc database) is fine. Those two lines have got to be the > problem. > > > Can you people help me out with this? > > If I have to give you my whole script (not very long) I will. > > Thanks for any help you can give me. > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >