Sorting data from MySQL and inserting it into a HTML Table

Question

I am currently monitoring 38 individual LED Lighting current and the data is being displayed/imported to a MySQL table. However, that is not what I want to achieve. I want to instead have a concept similar to a table you see in Stock market, where the values(current) are being replaced every other minute or so. Please do advice on how I am suppose achieve the desired outcome. Thank you.

Use jquery or a similar javascript library and just pole your database and update your view. — Ryan Rentfro
– Ryan Rentfro, Commented Dec 28, 2015 at 17:43

Ananda G · Accepted Answer · 2015-12-28 18:20:19Z

1

You can use MySQl Acceding or Descending order and short the values. like as

SELECT * FROM  `table-name` ORDER BY  `LED` DESC

answered Dec 28, 2015 at 18:20

Ananda G

2,54927 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:23:04Z

1

I suggest you use some kind of JS graph library. You can make a PHP script the get you data from the database, and use ajax to reload your data into a graph.

I'm, suggesting using HighChart.

This is a good example: Auto Update Highcharts with Ajax

edited May 23, 2017 at 12:23

CommunityBot

11 silver badge

answered Dec 28, 2015 at 9:04

Gal Silberman

3,9245 gold badges34 silver badges61 bronze badges

Collectives™ on Stack Overflow

Sorting data from MySQL and inserting it into a HTML Table

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related