MyBB Community Forums

ok.

Hi, already had time?

wow ! well not for checking that!

well when you order something in sql, it will order it depending on the cronological order of the number, 12345.

so having 1981 is less than 1990 , so that's why it is consedering it as younger

and as the entry is a date format, and not something like 1143749204, this problem will always accure.

but dont loose hope! i will find a way to trun it into time format (1143749204) then compare them.

regards

Thanks

Well, mysql can sort by ASC and DESC.
ASC is normal, the highest is first. DESC is the oposite.

like this.
mysql_query("SELECT * FROM ".$config['table_prefix2']."downloads ORDER BY id DESC"); id is an table column.

and ??!! this means what ? i have already used this to sort the birthdays, but as i have explained its because of the chronological order of number, the youngest person isnt precised .

regards

CraKteR Wrote:Well, mysql can sort by ASC and DESC.
ASC is normal, the highest is first. DESC is the oposite.

ASC is short for Ascending, meaning smallest to largest.
DESC is short for Descending, meaning largest to smallest.

Hi,

My test user got 2 e-mails.