MySql select just one and order by date and blog?

Question

Hello

I want to sort data from mysql.

The shema looks like this:

  id    int(11)        
  objectId  int(11)    
  type          tinyint(4)    
  field     tinyint(4)    
  value     int(11)    
  date          int(10)

id  objectId  type  field  value  date
1   1631  0  10  2918  1183  746534
2   1631   0   11   1108   1183  746534

Now My problem is I can't order by objectId and date Any idea?

Answer 1

If you want to order by object id first then date:

SELECT * FROM table_name ORDER BY objectId, date

If you want to order by date then object id:

SELECT * FROM table_name ORDER BY date, objectId

To get the results in PHP in the same order:

$res = mysql_query ("SELECT * FROM table_name ORDER BY date, objectId");

while ($row = mysql_fetch_object($res))
{
    echo "Object id: $row->objectId Date: $row->date\n";
}

Answer 2

if your dates and objectids are identical, it won't be much use sorting by them