[SOLVED] passing variables to mysql

[eon201]

Ok so, here is my new problem.

My script works out a variable (the users ip) and then needs to pass it to a mysql table.
Quite simple.

But the trciky bit is that I need my php to run this style of script before it posts the data to the sql.

Does the table for this hour exist? y/n (there will only ever be one hour table which needs to be overwritten each hour)
Does the table for this day exist? y/n (there will be a new table for each day)
Does the table for this week exist? y/n (there will be a new table for each week)
Does the table for this month exist? y/n (there will be a new table for each month)

Create the corresponding table if neccesarry.
Post the data to the all the corresponding tables according to the time and date.

By doing this I am keeping all the tables amended and can pull them back into another php file which will read the data and post it accordingly.

Ok cool. I hope someone has done this before, as im quite unsure how to do this.

[alexgeek]

The table for this hour? I'm not sure what you mean.
Are you creating tables with a cronjob?
What would an exmaple for a "table for this hour" look like / be named?

[Eran]

very simple
you need to add to your table a time-stamp cell.
then when you want to ask your questions you do it with a SQL statement
select * where `theTime` > time()
http://php.net/manual/en/function.time.php

[eon201]

ahhh... ok cool thanks! Ive got it now!