Hello All, Thanks for the all info !! I've done my query like this: SELECT id,SUBSTRING(FROM_UNIXTIME(unixtime),1,10) as unixtime,ip,porta_snmp,porta_switch,ip_cliente,mac_cliente from teste group by unixtime,porta_switch,porta_snmp; I've used SUBSTRING to get rid of the time from my unixtime... like this I could get my resoults. Thanks Alot, Gus ----- Original Message ----- From: "Snijders, Mark" <Mark.Snijders@atosorigin.com> To: <guslist@kerntec.net> Sent: Friday, March 14, 2003 11:25 AM Subject: RE: sorting problem... > hi, > > when you have them as unixtimestamp into your database it's impossible to > group by this field, cause for every second this field is different... > > can you please try the output of this: > > select FROM_UNIXTIME(unixtimefield) from table > > and see if you now get back normal dates... > > if it;s work try this (don't know if its work, don't think so but try it... > and tell me the results) > > select FROM_UNIXTIME(unixtimefield) from table group by > FROM_UNIXTIME(unixtimefield) > > -----Original Message----- > From: guslist@kerntec.net [mailto:guslist@kerntec.net] > Sent: vrijdag 14 maart 2003 15:10 > To: Snijders, Mark > Subject: Re: sorting problem... > > > Hi, > > The problem is that using 'group by unixtime' I get back all my rows from my > table, once each record for unixtime is difrent (I save as UNIXTIME: > 1041949404). > If I try to 'group by porta_snmp' I get back only uniq records... but I have > uniq records from day 2003-01-07 and 2003-02-07. > > Any help ? > > Thanks, > Gus > > ----- Original Message ----- > From: "Snijders, Mark" <Mark.Snijders@atosorigin.com> > To: "'Ignatius Reilly'" <ignatius.reilly@free.fr>; <guslist@kerntec.net>; > <php-db@lists.php.net> > Sent: Thursday, March 13, 2003 11:08 AM > Subject: RE: sorting problem... > > > > guess you can better take a look at the group by function of mysql > > > > > > > > -----Original Message----- > > From: Ignatius Reilly [mailto:ignatius.reilly@free.fr] > > Sent: donderdag 13 maart 2003 15:03 > > To: guslist@kerntec.net; php-db@lists.php.net > > Subject: Re: sorting problem... > > > > > > Take a look at the MySQL DATE_FORMAT() function. > > > > Ignatius > > ____________________________________________ > > ----- Original Message ----- > > From: <guslist@kerntec.net> > > To: <php-db@lists.php.net> > > Sent: Thursday, March 13, 2003 2:43 PM > > Subject: sorting problem... > > > > > > > Hi All, > > > > > > I need to sort some data from a MySQL table. I have data saved like > this: > > > > > > +----+---------------------+------------+--------------+ > > > | id | unixtime | porta_snmp | porta_switch | > > > +----+---------------------+------------+--------------+ > > > | 1 | 2003-01-07 12:23:24 | 1614 | 1 | > > > | 2 | 2003-01-07 12:24:01 | 1614 | 1 | > > > | 3 | 2003-01-07 12:29:34 | 1614 | 1 | > > > | 4 | 2003-01-07 12:30:19 | 1614 | 1 | > > > | 5 | 2003-01-07 12:31:01 | 1614 | 5 | > > > | 6 | 2003-01-07 12:32:06 | 1614 | 5 | > > > | 7 | 2003-01-07 12:33:01 | 1614 | 1 | > > > | 8 | 2003-02-07 12:34:06 | 1614 | 1 | > > > | 9 | 2003-02-07 12:35:00 | 1614 | 1 | > > > | 10 | 2003-02-07 12:36:01 | 1614 | 1 | > > > +----+---------------------+------------+--------------+ > > > > > > I neet to sort the data to be able to read it better. In this case I > just > > > need to filter the data to get only the different info for each day. > Some > > > thing like this: > > > > > > 2003-01-07 1614 1 > > > 2003-01-07 1614 5 > > > 2003-02-07 1614 1 > > > > > > Is this possible ? > > > > > > Thank's in advance, > > > Gus > > > > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
