Macros For MySQL Functions

; ==== MYSQL FETCH ============================================================
[macro-MYSQLFETCH]

exten => s,1,MYSQL(Connect connid localhost asterisk yourpassword asterisk)
exten => s,n,MYSQL(Query resultid ${connid} ${ARG2})
exten => s,n,MYSQL(Fetch fetchid ${resultid} ${ARG1})
exten => s,n,MYSQL(Clear ${resultid})
exten => s,n,MYSQL(Disconnect ${connid})


; ==== MYSQL UPDATE ===========================================================
[macro-MYSQLUPDATE]
exten => s,1,MYSQL(Connect connid localhost asterisk yourpassword asterisk)
exten => s,n,MYSQL(Query resultid ${connid} ${URIDECODE(${ARG1})})
exten => s,n,MYSQL(Disconnect ${connid})