Sorting Dlm Php

[hasmilia 0]

ASC...

[hasmilia 0]

kenapa kalu saya run sql statement ni dia x paparkan ikut turutan...

$sqldb = "SELECT harga,tempoh FROM $noSebutHarga ORDER BY harga";

input

22

111

55

333

output yg keluar(slh)

111

22

333

55

output sepatutnye

22

55

111

333

ada sesape yg leh bantu x??

Edited May 29, 2006 by hasmilia

[ejoe 0]

22,111,55,33t tu semua dlm field harga ke?

try 'SELECT harga,tempoh FROM $noSebutHarga ORDER BY harga ASC'

pastu

'SELECT harga,tempoh FROM $noSebutHarga ORDER BY harga DESC'

cuma kame sure "ORDER BY harga" filed yg betul kita nak sort...

[hasmilia 0]

ha'ah dia dlm field harga...sy da try da mcm yg ejoe suh...tapi still xboleh...bila tukar kpd DSC...

output dia jd

55

333

22

11

Edited May 29, 2006 by hasmilia

[ejoe 0]

ish pelik tu

try sort guna field lain jadi tak cam

'SELECT * FROM namatable ORDER BY tempoh'

or field lain

[hasmilia 0]

ermm still xbole jgk...

[ejoe 0]

field harga tu jenis ape?

vachar? char? int?

[hasmilia 0]

ermm jenis varchar...patut la xdpt...anyway tq ya ejoe...jasa mu akan d kenang

Edited May 29, 2006 by hasmilia