DarkReaper Posted September 22, 2006 Share Posted September 22, 2006 Hello i have a table with structure: [code] `id` int(10) NOT NULL auto_increment, `site_id` int(10) NOT NULL default '0', `time` int(10) NOT NULL default '0', PRIMARY KEY (`id`), KEY `site_id` (`site_id`)[/code]My problem is that i want to select all entries by days. My date cell is time, and its unixtime stamp. I know how to select the entries from today ... but i want to group them by all the days available.[code]SELECT count(id) as total FROM uniques WHERE site_id=2 GROUP BY TO_DAYS(FROM_UNIXTIME(TIME));[/code]This code returns all the entries from today. Because of the "TIME" code. I've tried also:[code]SELECT count(id) as total FROM uniques WHERE site_id=2 GROUP BY TO_DAYS(FROM_UNIXTIME(uniques.time));[/code]But the result was the same. Helppp :)Short version: I have the table from above, i want to select all entries grouped by days. My time stamp is the unix default and its stored in the cell -> time.--------------------WHOOPS! My bad. I've forgotten to cycle though the returned rows ... sorry the [code]SELECT count(id) as total FROM uniques WHERE site_id=2 GROUP BY TO_DAYS(FROM_UNIXTIME(uniques.time));[/code] Does the trick. Case closed :) Quote Link to comment Share on other sites More sharing options...
DarkReaper Posted September 22, 2006 Author Share Posted September 22, 2006 My last problem is that i have 3 tables, and i need the data from them to be merged by this sql query.The tables are as follows uniques, impr, vis. I need to extract the same data at the same time from them, with 1 query. I know how to do it with multiple queries but i dont like that way, its too uniefficient. Quote Link to comment Share on other sites More sharing options...
fenway Posted September 22, 2006 Share Posted September 22, 2006 I'm not sure I understand what you mean. Quote Link to comment Share on other sites More sharing options...
DarkReaper Posted September 22, 2006 Author Share Posted September 22, 2006 I have 3 tables. Each of them contains information for a specified period of time by the column "time".I want to print for example the information from the 3 tables for yesterday/2 weeks ago or any other date i want. Quote Link to comment Share on other sites More sharing options...
fenway Posted September 22, 2006 Share Posted September 22, 2006 So you simply want to combine the individual queries from each table? Quote Link to comment Share on other sites More sharing options...
DarkReaper Posted September 22, 2006 Author Share Posted September 22, 2006 Yes. Quote Link to comment Share on other sites More sharing options...
fenway Posted September 22, 2006 Share Posted September 22, 2006 Assuming that you select the columns appropriately, UNION will allow you to do this. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.