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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
