AshleyS

Hello, I store continuous updating data every 60 seconds, and I want to use the JQuery graphing tool called Flot (http://code.google.com/p/flot/). I would like to show the data in datasets of 'Per hour' and 'Per day', but I have no idea how to show this, and what data to use. I'm familiar with SQL and PHP, but when it comes to math - not so bright! Can someone please help me out and point me in the right direction of what queries I need to run and what data to output? Many thanks.

Thank you Orio, you've explained it very well and I can understand how it operates. Many thanks.

Thanks for the code, Orio. It works just as I needed. If you have the time, would you be able to explain each segment of what is used in the preg_replace? Regards.

Thanks for you speedy reply, here is an example of data we get from a batch of mp3 song titles. (We run a DJ system.) 8. 3 Doors Down - Kryptonite 207. Aerosmith - I Don't Want To Miss A Thing 1096. Coldplay - The Scientist 1097. Coldplay - Trouble 1832. FatBoy Slim - Praise You 1833. FatBoy Slim - Right Here, Right Now 2068. Green Day - Time your life 3 Doors Down - Kryptonite Aerosmith - I Don't Want To Miss A Thing Coldplay - The Scientist Coldplay - Trouble FatBoy Slim - Praise You FatBoy Slim - Right Here, Right Now Green Day - Time your life The index numbers can go up into the high thousands, so I cannot specify a range from where it will go up to. Regards.

Hello, I've done quite a bit of searching to try and figure how to accomplish this. We receive strings like the following: 1. Some text with commas and periods. 20. S.A.T.S - School Exam 3523. 5 Stars. Basically, I need to be able to strip everything before the first period, leaving just the underlined text. I do not have much knowledge with regular expressions, so could please someone assist? Regards.