Asterisk and Mysql

Asterisk Asterisk Support
1

Im trying to get a dialplan to read data(dtmf) and insert it into a db, have an mysql db setup. with read/write permissions. Db name = testdatabase user = admin.

here is my code i have used thus far. any help to why this isn’t working would be helpful

  include=default
  include=parkedcalls
  include=conferences
  include=ringgroups
  include=voicemenus
  include=queues
  include=voicemailgroups
  include=directory
  include=pagegroups
  include=page_an_extension
  exten=500,1,Answer(500)
  exten=500,n,MYSQL(Connect connid localhost admin metro02 testdatabase)
  exten=500,n,Wait(3)
  exten=500,n,Authenticate(63876)
  exten=500,n,Playback(EmployeeID)
  exten=500,n,Wait(1)
  exten=500,n,Read(EmployeeID,beep,8,si,2,20)
  exten=500,n,Wait(2)
  exten=500,n,Playback(WorkOrder)
  exten=500,n,Wait(1)
  exten=500,n,Read(workorder,beep,8,si,2,20)
  exten=500,n,Wait(2)
  exten=500,n,Playback(Inspection#)
  exten=500,n,Wait(1)
  exten=500,n,Read(inspection,beep,8,si,2,20)
  exten=500,n,Wait(2)
  exten=500,n,Playback(Status)
  exten=500,n,Wait(1)
  exten=500,n,Read(status,beep,8,si,2,20)
  exten=500,n,Wait(1)
  exten=500,n,MYSQL(Query resultid ${connid} INSERT INTO statreport (woid,inspnum,empnum,status) VALUES  ({workorder},{inspection},{EmployeeID},'{status}'))
  exten=500,n,Playback(ThankYou)
  exten=500,n,Wait(3)
  exten=500,n,MYSQL(Disconnect ${connid})
  exten=500,n,Hangup()
2

here you are again

INSERT INTO statreport (woid,inspnum,empnum,status) VALUES ({workorder},{inspection},{EmployeeID},’{status}’))

needs to be

INSERT INTO statreport (woid,inspnum,empnum,status) VALUES (${workorder},${inspection},${EmployeeID},’${status}’))