data storage

[Ben Phelps]

I need a good way to store data for each day, but it needs to be accessed easily.

 

data 1 - 125478

data 2 - 123549

 

Those numbers would change each day, and i need to store that value for each day.  It would be kinda like a stats archive.

 

I would need to refer back as far as one year from the first date.

 

Is there an easy way to do this?

[deadimp]

There are a lot of options you have. Some of them are:

> Store in simple text, with explode() and implode()

> Store in XML, parse/generate it with SimpleXML or something like that

> Store the data using MySQL or other db software

[Ben Phelps]

I would be storing hundreds of thousands of entry's that would each be updated every day, so it would need to be MySQL, but i need a simple way to store that in MySQL.

 

I just don't know how to store that data so it can be accessed to create a graph or plot a chart.

[teng84]

to create a bar graph heres my idea

 

hmmm..

get the total of the record say group by male the the number you will get will be the hight of the image or etc you will use

 

does that make sense

[Ben Phelps]

i think i figured it out.

 

 

each data set will have its own table

 

i will use a unix timestamp to make the time

 

and i will update it every hour

 

then all i have to do is a loop to get the data for a graph and whatnot

 

is there a better way to do this ?

[teng84]

yes and maybe no

no need for the loop do you know the group by clause of sql thats better

[deadimp]

This question might be better answered if it were in the MySQL forum. I'm not sure I can contribute anything else to this.