What is wrong with my query?

[refiking]

I am trying to sort the results by (added) which is a timestamp, but it isn't sorting them by the timestamp.  Some of the most recent entries (which should appear at the top) or going down to the middle.  Here is the query:

$sql = mysql_query("select * from records where `read` < 1 order by added");

[jonsjava]

forgot to tell it how to order (ascending, descending)

$sql = mysql_query("SELECT * FROM `records` WHERE `read` < 1 ORDER BY  `added` ASC;") or die("ERROR, Will Robinson! Here it is:\n".mysql_error());

[refiking]

I tried that, here's a few of the values I got:

 

2010-03-27 01:24:32

2010-03-26 01:39:00

2010-03-26 11:54:00

2010-03-27 12:23:48

2010-03-27 12:23:48

 

And that's the exact order they were displayed in...

[jonsjava]

might be better to store dates in unix timetamp. Easier to calculate.

[PFMaBiSmAd]

The default ORDER BY by is ASC. If the column is a mysql TIMESTAMP data type, what you are doing will work.

 

What is the column definition and how did you produced and enter the values?

 

Also, what is your code that is retrieving and displaying the results?

 

Short-answer: There's nothing wrong with the method you are using and it should work, assuming the column, the data, and your code is what you are implying.