how to use dynamic variables in the sql query

Hi

use this format to write query for pie chart
select `first column name(can be integer or string)`, `second column name (should be integer or float value)` from `table name`

Thanks
Zaheer

Hi! that is also an interesting topic for me. any follow up on that?
Do you have any example of a sql code for a query? I am trying to build sql pie chart, the code I created works for bar, but not for pie chart.
thanks

i dont know the number, because the plugin was boss samlee give me to install. if he give me the number, i will tell you in the first time.

i see the thing in vchart was: You can also include dynamic variables in your SQL query. You just need to enter variable name within curly braces. e.g. {catid}. {loggedinuserid} is reserverd for Logged-in User.
nut i don't know how to use the dynamic variables in my sql query, and when i want to use dynamic variables, what should i do.
please help me.