Re: odbc_exec error

Scott Wettstein wrote:

I'm pretty new to PHP so I need help. I'm getting this error: Error in updating SQL PHP Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2., SQL state 07001 in SQLExecDirect in c:\Inetpub\wwwroot\shout.php on line 77 Lines 76 and 77: $sql="UPDATE shout SET UserName=$laName,Message=$laMessage WHERE Dat=$laDate"; $updating=odbc_exec($conn,$sql); where $laName, $laMessage, and $laDate are from a POST. I've checked my spelling a million times and changed the names of variables. Why is it still complaining? Please help! it says a SQL error ;-)

I would check to see if you need quotes around your variables... like: $sql = "update shout set UserName='$laName', Message='$laMessage' where .... -Brad