(and under that the data comes)
Under these columns there might be generated 100's or 1000's lines hourly, so i need to make it as fast as possible. This table will be displayed in many of the pages.
The code i got so far is prety slow, because it "while"-loops single line till the prefered amount of lines is reached, alot of unnecesary mysqlqueries. I've tried to look at different docs and tutorials, but can't figure it out.
What would be most efficient way to fetch top 30 lines and converting 'orderid' 'volume' 'sellerid' 'buyerid' 'brokerid' 'ordertime' 'price' 'quote' into different-php-variables (different, imean like: $orderid = 'orderid') ?