odbc_exec error
| From: | Scott Wettstein | Date: | Thu, 01 Jun 2006 19:19:50 +0000 |
| Subject: | odbc_exec error | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-41968@lists.php.net to get a copy of this message | ||
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!