danago

Thanks very much for those links! I read through them all and found some very handy information.

One for each object that i need to keep data on. Is there a better way to do it?

Basically, the max, min and market prices will change everyday. The item name and ID will remain the same. So it basically means adding one new row into each table each day, rather than just updating the rows, because id like to keep a histoy of the price data. So are you saying it is viable to have 500+ tables in a single database? Because that would pretty much solve this for me Thanks for your replies, Dan.

Sure: Object Name Object ID Date Minimum Price Market Price Maximum Price Thats pretty much it on the information that i need to store. The price information updates approximately once per day.

I dont really have a solid design, but i thought about perhaps creating a separate table for each of these objects, and then a separate row in each table for each updated piece of information. I guess my biggest concern with this is that i dont know if this will be efficient, or even possible? Things have changed a little and i will no longer have 15000 objects to collate information on; the number has been cut down to less than 1000 (not sure on precise number yet). Is it at all viable to have a database with 1000 tables? Sorry if i have missed out on some vital information that you need to assess the situation. Like i said, i am fairly inexperienced with mysql, and this is more of a personal project so i didn't really want to hire someone to do it professionally. Thanks for the reply. Dan.

Thanks for the help guys. To answer your question severndigital, it is just a website displaying the information. I managed to write up a script that does exactly what i need. The regular expressions for the preg match all function werent too hard to write since the extractions were fairly easy to do Thanks again, Dan.

Hi. I am fairly new to mysql, and just had a question about organizing some information. What i wanted to do was store information about approximately 15000 objects. There are 5 pieces of information i need to store for each object. Where the problem comes in is updating the table. Of those 5 pieces of information, 3 of them change daily, so i need to somehow add those into the database, without replacing the old values. I basically need to keep a historical record of this information. Does that make sense? Im not even sure if this is viable, so any input is appreciated Thanks in advance, Dan.

Hi everyone. Just signed up Anyway, i have some basic knowledge of php; i am able to create basic working scripts etc., but nothing too extensive. Im thinking about starting a project, but before doing so, id like to extract some information from a database that is publically available from a certain website, so that i can re-organize the data into a way that will be most useful to me. The data i extract will not be for commercial use, so the method does not necessarily need to be the most efficient method. Is anybody able to suggest a function or class that i should perhaps look into that can do this type of thing? Thanks in advance. Sorry if i have not explained myself clearly enough. Dan.