php - 如何在 msaccess php 中将列值设置为变量

Question

我的查询:

$att="select
      AttData.Rollno,AttData.Name,AttData.Year,AttData.sec,AttData.".$date." 
      from AttData where AttData.sec='".$sec."' and AttData.dept='".$dept."' 
      and  AttData.year='".$year."' and AttData".$date."='AB'  ";

我的数据库设计 View 是

我的错误

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'AttData.sec='A' and AttData.dept='cse' and AttData.year='IV' and AttData'02-07-2016'='AB' ''., SQL state 37000 in SQLExecDirect in C:\wamp\www\sms1.7.16\repotdaygen_allyear.php on line 325 select invalid37000

Answer 1

试试这个...我在两个位置的 $date 周围添加了方括号

$att="select
      AttData.Rollno,AttData.Name,AttData.Year,AttData.sec,AttData.[".$date."] 
      from AttData where AttData.sec='".$sec."' and AttData.dept='".$dept."' 
      and  AttData.year='".$year."' and AttData[".$date."]='AB'  ";