need to build a chart from data in my local mysql database

Job ID: 34400532

Budget: ₹600 – ₹1,500 INR

hello team,

i have a table with 6 columns.

name, total buy quantity, total sell quantity, time, date, price.

i want a line chart, on x axis i want to display time and price.
on y axis, need to show total buy and sell quantity with 2 different lines.

on page top, i need a filter with name and date, so that i can see that data. my database updates every 1 second, so i want to see the live data on my chart. i need to have a zoom in and zoom out of the line chart.

thanks.
Related categories: PHP Visual Basic MySQL Charts Data Visualization